Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 247 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 91 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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
DPM
Rank 2 - Community Beginner
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
0
Answers
-
Hi DPM,
Please check if this helps:
How to Use Presentation Variable in a Dashboard Prompt Where Date Operator is "Is Between"? (Doc ID 2447159.1)
Let me know if you have any questions.
Priscila Terazawa
0