How to pass value of Presentation variable across dashboards and analysis?

Sudipta Gupta

Hi Gurus,

I have a report in a dashboard pivoted on date column ( showing values for past 4 dates).

I'm using a Dashboard Prompt on the Date column and storing the same value in Presentation variable called "V_DATE".

Now I have created several drill down reports where I created Action Link using "Link to a Web Page" (GO URL) option and using the target report url to pass all parameters including the Presentation variable "V_DATE".

When it goes to Report 2 from Report 1, it passes all column values including the Presentation variable "V_DATE". But when I'm doing the same to drill down from Report 2 to Report 3, all parameter passes value except the Presentation variable "V_DATE". This is because, the analysis (Report 2) is outside the dashboard scope I believe.

• Can anyone please suggest me what is the alternative to achieve this?
• Can we refer the user selected Dashboard prompt value outside of the dashboard scope?

I'm using OBIEE 12c version.

Any help is highly appreciated.

Thanks in advance.

Regards

Sudipta

Jerry Casey

Hi Sudipta,

I'm no guru, and I'm working in 11G, but one method I've used is to place a hidden prompt on the target dashboard page.  This is done in the Dashboard Edit/Dashboard Properties screen:

           

I use an action link in the originating report that "Navigates to BI Content" (your target page).  In your case, clicking on the Date column sends the date to the target page.  The hidden prompt is set to create your "V_Date" presentation variable.  All reports on the target page will respond to the prompt, if they are filtered on V_Date.  Remember, the hidden prompt is a Dashboard property, so your presentation variable should be unique to your target page, unless you desire a multi-page response.

Good luck,

Jerry Casey