Obiee 12c date drop down for dashboard

Maya J

Good Morning,

I am trying to create a prompt that will save the current instance of my dashboard page daily .  The idea is that the user should be able to choose if they want to view the current dates data on the dashboard or that of a previous day's, from dates listed in a drop down menu.  I am not sure how to go about this and any help will be greatly appreciated.

Thank You

[Deleted User]

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ps/ps.htm

Oracle has a whole range of free small tutorials around this topic

Gianni Ceresa

Hi Maya,

What you look for is a fairly standard thing to have in a dashboard.

The theory is that you create your dashboard prompt using a column of your time dimension, and you then have filters in your analysis (included in the page) which use that same column (set as "is prompted" or even set to a fixed value: the prompt will override that fixed value with the one selected).

So it's something requiring to have the 2 sides of the dashboard ready for it: the prompt on a side and the analysis on the other able to use the selected value.

If you have a more precise question or if you can define more precisely what you managed to do and where you are stuck it will be easier to give you a better reply.

EDIT: Christian was faster, that's what happen when writing lot of blabla instead of a link and few words ...

Maya J

Hi Gianni,

What I ultimately want to create is the picture below, which was set up by someone else in 10g. I already have the prompt created for the dashboard based on my time dimension, I am just not sure how to capture the current state of the data and equate it to the current date. How they have it in the picture below is that every time the table is updated the data is saved  and represented as a times tamp, allowing the user to view past data by clicking on the time stamps listed in the drop down. The dashboard than reloads to match the data on that given day .

I tried using a briefing book to do something similar, but I did not like the result.

Hope that was clearer

Gianni Ceresa

Ah, that's a slightly different story.

It actually depends on your data sources and model.

It's a bit like when you a SCD2 dimension and you want to move back and forth in time to see the "snapshot" of data at different points in time.

So it's still doable, but you need to have your data source having that information available (snapshots loading or incremental load with SCD2 versioning approach) and then to model your RPD exposing that information to allow you to select it with your prompt value.

Briefing books simulate that in the way that they are like "snapshots" of your data at a given point in time.

Just to be sure: you want to select a day and see all the data available at that day (so even multiple months data as it was known at that day) and not just select a date and see the data of that given day only, right?

[Deleted User]

This time beaten by Gianni. Yes it  does look like you want to jump around in time along snapshots.

So long story short first reply to Gianni's question and then think about the following: A distinct snapshot dimension and a distinct time dimension will allow you to split the two concepts of time.

Maya J

I would like to be able to select a day and  see the tables reflect that data on that given day.

Gianni Ceresa

Maya J wrote:I would like to be able to select a day and see the tables reflect that data on that given day. 

So you need to have in your tables the required versioning to be able to select a given day snapshot. Do you have that?