How can we add date parameters through advance SQL in OTBI?

Sushant95-Oracle

Hi All,

We have a custom OTBI report that in which we want to add some date prompts, Can anyone guide me how to add date prompt from advance sql?

How we refer parameter from advance sql query to OTBI prompts?

Rajasekhar Bandaru-Oracle

Hi Sushant

Please try the below

In the Criteria tab—>Select the required date column—>Click on Filter—>select the check box "Convert this filter to SQL"—>In the Advance SQL text box enter the SQL as per your requirement and save the analysis.

Refer to the given help centre documentation link

Creating Analyses and Dashboards in Oracle Transactional Business Intelligence