Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How AsOfDate working in FAW?
Meme 0101
Rank 3 - Community Apprentice
In OTBI, we can run a report with an effective date by putting for example SET VARIABLE PARAM_EFFECTIVE_DATE='2021-07-31'; in the PREFIX. This would show us how the data looked on a specific day in the past/future.
How would we do this in OAC/FAW? I have created a report based on the HCM Core Subject Area but I wish to run it as of a certain date - ultimately I would have this as a prompt so the user can set the effective date themselves e,g, Run report as of..
0
Answers
-
Hi @user966776 ,
Please try the below link:
"Create a Date Part Parameter in Oracle Analytics"
Thanks
Subha
0
