1,778 total views
For most of the BI Reports we have the input parameter as “AsOfDate” alias sysdate or current date… Sometimes we also have a date range “From Date” and “To Date” to fetch transactions between those dates. And these dates need to have a default value when we open the report/schedule the report.
Want to learn Fusion Technical tools go through this post
In this article we will try and see what are all the options possible for defaulting date parameters for BI Report.
We can use these values in the BI Data Model as the default values and when the report is scheduled, the dates will be picked up dynamically based on the sysdate.
Using the above expressions you can populate the default date values when you run the BI Publisher report.
Latest posts by Sricharan Monigari (see all)
- Renaming HCM Extracts is a possibility from 20D - November 24, 2020
- Sangam20 – Oracle Users Group Conference - November 23, 2020
- Passing Parameter values from Flow Instance to HDL Transformation Formula - November 23, 2020
- Solve manual FTP server update issue for HCM Extracts post every P2T refresh - November 16, 2020