Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Default date value in oracle dashboard prompt

Received Response
21
Views
1
Comments
Saud
Saud Rank 3 - Community Apprentice
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

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

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    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!