Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to use the prompt in the Filter condition

Received Response
2
Views
1
Comments

Currently we donot have a prompt and report fetches the data for the sysdate, with the filter condition as CURRENT_DATE BETWEEN "- Enrollment Results"."Enrollment Coverage Start Date" AND "- Enrollment Results"."Enrollment Coverage Through Date"

Requirement is, to run the report based on a Date that will be prompted. So, Instead of the CURRENT_DATE, the Prompt date should be used.

How to achieve this.

Thanks

Answers