[OIC] Passing Default Value to Date Parameters in Oracle BIP Reports

on

Oracle BIP Reports allow users to generate data-driven insights with dynamic parameters. One common requirement is to set default values for date parameters so users can run reports without manually selecting dates. This blog post explains how to set default values for date parameters in Oracle BI Publisher (BIP) reports.


Steps to Pass Default Value to Date Parameters

  • For this demonstration, I have created a Data Model with below SQL Query:

               SELECT :P_DATE  
               FROM DUAL

  • Also, Updated the date format string to dd-MMM-yyyy to display dates in the format 15-Apr-2025 for better readability and consistency.






  • When clicking on View Data, the data parameter is currently coming as blank


  • To enhance functionality, we want it to automatically populate with the current system date if no value is provided. To achieve this functionality we can write {$SYSDATE()$} in the Default Value text box:





  • Now, when you click on View Data you will see the current date automatically populated



Below are the other expressions that you can use:




Comments

Post a Comment