Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not working
We are running some of our OTBI reports with a variable for a user-prompted date (data for a specific date).
Currently, the report variable uses and displays the wrong date format
We set the Prefix as:
SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}';
The return message is: "No Results"
When typing the date format 24-06-30, the report runs but retrieves data up to 24-06-2030 instead of 30-06-2024.
Is there any way to set the variable format?
Answers
-
Hi @rrr,
Have you tried entering the century as well?
The format is set to YYYY-MM-DD so maybe try 2024-06-30?
0 -
2024-06-30 retrieves "No Results"
0 -
Have you set up the Presentation Variable similar to below?
If yes, could you please attach your xml for your report?
Thanks
Mark
0