How to add yesterday's date to dashboard title

Mik A.M.

I have a dashboard that pulls all data from the previous day (yesterday).  I'm trying to add this date to the dashboard title.  So, for instance, if the dashboard were viewed today, the title would say "Data for 03/14/2016" and the date would update for whenever it was run.  I'm unable to get this to work in the title or subtitle settings.

Any assistance would be appreciated.

Thanks.

cesar.advincula.o

Hello,

Do you mean to a the Dashboard Page?

Or the dashboard?

Kind Regards,

choracy69

Hi,

I think that you can use repository variable in this situation.

In title try use something like that: @{biServer.variables['rpd_variable_name']}

For current day you can use: @{biServer.variables['CURRENT_DAY']}

But I think that for PREVIOUS_DAY you must create rpd_variable manualy.

Create Initilization Block for example: SELECT CURRENT_DATE-1 FROM DUAL

And next create dynamic repository variable.

Look here: OBIEE: Syntax for Repository Variables in different places

Mik A.M.

I meant as on the dashboard itself, the chart I have presented will show "Data for 03/15/2016", since it ran this morning and is showing yesterday's data.  But if it can be added somewhere so the end user knows this data is yesterday's data, that would be great.

Thomas Dodds

Use a small section on your dashboard page which displays a narrative that is sourced from your ETL control table ...

Sher Ullah Baig

Step 1: Create Analysis take any column (dummy column)

Step 2: Past below to get yesterday Date

TimestampAdd(SQL_TSI_DAY, -1, CURRENT_DATE)

Step 3: Save Analytics

Step 4: Drag and Drop on Dashboard Section where you want to show to your users.

hope this will help u.

regards

cesar.advincula.o

Hello,

Sorry by the delay, well your last run refresh("the date would update for whenever it was") as you have to implement a mechanism in.your ETL process to get the date time.of when was your last refresh, maybe you could get into the database table has a register of your log time execution process( start.time, end time, how long of the execution of your ETL / ELT process), your could a. Narrative, table.inside your dashboard to show their last refresh date time.

In the other hand, you have a hardcode data as timestamp(sql_tsi_day, -1, current_date), which so fast to implement and you dont need any special mechanism, however you should be careful, what happened? If you get some issue in your execution ETL process??

Kind regards,