Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Dynamic date variables using 'Between' calendar date prompt
slgott
Rank 4 - Community Specialist
Summary
How do I set dynamic, default server variables on a calendar date that uses 'between' dates?
Content
Hello,
I want to set a default date value on my dashboard date prompt. I know there are many options for BI variables to use. I have the documentation and have already looked through: 'REL11_Oracles_Sales_Cloud_BI_Variables_03-Aug-2016.pdf' Oracle doc. I am looking for a way to set my dates to default for a "Between" calendar date 14 days back and to present day. Any thoughts?
Thanks,
Stephanie
0
Comments
-
You need access to the RPD to set variables system-wide (server variables) - not sure how OTBI would allow you to do that.
0 -
Hi the current date is CURRENT_DATE then use CURRENT_DATE - 14
0
