How to Schedule a BI Publisher Report with Dynamic time range in parameter Values
Issue Description:
We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle's standard reports, the "BIP Report Audit Trail," located in the Audit Reports section.
The Client specific requirement is to filter the report data based on a dynamic time range, such as the last 2 or 4 hours, and to have these time range parameters be dynamically adjustable when scheduling the report.
Current Challenge:
In our initial attempt to meet this requirement, we utilized the following parameters to retrieve data for the past 24 hours: {$SYSDATE()-1$}
Tagged:
5