Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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
1
Views
1
Comments
DPM
DPM Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence Forum

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