Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Default date value in oracle dashboard prompt

Hi all,
I would like to know how to add default date in dashboard prompt. I tried this SQL result
"SELECT TIMESTAMPADD(SQL_TSI_WEEK,-2,Current_Date) saw_0 FROM "DIM_PERIOD""
but some times it works and mostly it doesn't work. When I add remove the table and add it again it works but after some time it shows (All Column Value).
Any help would be appreciated.
Thank you.
Answers
-
I must say...it is very weird that the way you are doing it is not working. I tried it on my end and could not get it to work either.
To get it to work, I wrote something like this:
SELECT "Date"."Date" FROM "Sales-SubjectArea" where "Date"."Date"=current_date
The key here was that I added a 'where' clause and it seemed to work.
So maybe yours could be something like:
Select "DIM_PERIOD"."DATE" from "<subject area>" where "DIM_PERIOD"."DATE" = TIMESTAMPADD(SQL_TSI_WEEK,-2,Current_Date)
(I realize that the query I give may not really make sense in your subject area -- like you may not actually have 'Date' in your DIM_PERIOD dimension. But I'm just trying to show how maybe using the WHERE clause might help)
Hopefully this helps!
0