Oracle Analytics Cloud and Server

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

Variables failing to apply in Briefing Books in 12c

Received Response
1
Views
1
Comments
1226945
1226945 Rank 1 - Community Starter

Hi, all. Curious if anyone has had a similar experience. I thought I had read about a bug in version 11 that sounded eerily similar, but can't for the life of me find record of it anymore on the support site...

Here's my scenario:

I have 3 nearly-identical Dashboards. All 3 of them source back to the same set of Analysis reports.The only difference between them is their defaulted Prompt values. I created a separate Prompt for each Dashboard, but otherwise they are the same. The Prompts pass values into the Analysis reports in the Dashboards reports via Presentation Variables. When you run each Dashboard individually, you obtain the expected results for each unique data set, call them "Result Sets 1, 2 and 3." The underlying analysis reports all default to the data consistent with Results Set 1, but are overridden by the Variables in the Prompts of each Dashboard.

Meanwhile, I created a Briefing Book based on the pages of those three Dashboards. The desired outcome is that the 3 Dashboards (3 result sets) can be scheduled and delivered to a large audience in a single PDF. However, the Presentation Variables do not appear to be applying in the resulting briefing book. I end up with Results Set 1 repeated 3 times. I'm assuming that the Briefing Book is just not applying the Presentation Variables form each Dashboard, and I'm getting only the default results of the underlying Analysis instead. I should note that these briefing books were working properly in version 11g, but this outcome started after we upgraded to 12c.

Would like to know if anyone else has experienced issues with Briefing Books and Presentation Variables, and if they discovered a workaround. I would rather not have to create 3 different sets of Analysis Reports each with their input parameters hard-coded, as it would defeat the purpose of using Variables, and would not scale if needed to add more Result Sets to this package in the future.

Eager to hear back!

Thanks!!

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    I would have personally used a slightly different approach.

    I'd use a request variable which is set on the dashboard prompt to determine which of the 3 dashboards has been called. You can then set session variables that hold the values that you need to pass to your analyses for that dashboard based on the request variable's value. The request variable helps you identify which dashboards is being called and then you can set session variables based on the request variable value.