Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Sudipta GuptaJul 11 2017 — edited Jul 12 2017

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2017
Added on Jul 11 2017
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
1 comment
905 views