Dashboard prompts and analysis level prompts

3427784

Hello all,

I have a dashboard with a dashboard prompt that will have a drop down for a user to select 3 different types of reports. Each of the 3 reports has their own prompts on the analysis level (user can select FY, REGION, STATE) after selecting a report from the dashboard prompt.

Problem - if a user selects a report and applies the analysis level prompt the report generates just fine. The problem happens when a user wants to select a different report (dashboard prompt) and drill down on that report using the "analysis" level prompts. The analysis level prompts do not show up and just quickly generates a report based on the last applied values.

Anyone have an experience with this?

Thank you.

[Deleted User]

Weird way to do it. Are you nesting in-line analysis prompts under a page that has a dashboard prompt? I can imagine that that throws off the engine.

Why not have multiple pages and use proper dashboard prompts? In-line analysis prompts are dodgy.

3427784

I completely understand your perspective Christian. However, customers would like to set it up this way and I truly feel that is throwing the engine off. After research it seems there are workarounds (hiding the reset button and creating a new one using HTML markup), but now I am stuck trying to style the new reset button to be aligned with the "apply" button. Configuring with the look and feel in OBIEE can be a pain sometimes..

[Deleted User]

3427784 wrote:However, customers would like to set it up this way 

So why does your client employ a technical resource if he already knows the solution?

Remember. WHAT to solve is different than HOW to solve it. tl;dr - trying to do it this way at all costs is just a wrong way of approaching the issue but good luck with it.

3427784

Solution -

Found out there is a specific logic on how the built in "reset" button executes. It does not reset the values as I'd like for it to. If had 3 different reports (e.g. Sales, Accounts Receivable, Monthly Bills) and selected "Sales" report and this report has its analysis prompts which can be Year, State, City, etc. If I wanted to go back and check out the "Monthly Bills" report, it will not prompt me again for the second level analysis prompt. Quick fix was to create a customized javascript "reset" button

First -turned off "apply" and "reset" buttons in the dashboard properties

Second - created customized "reset" button

Third - added to dashboard and users can use "reset" button which will clear all values and will enable users to select analysis level prompts.

Hope this makes sense. If anyone is working on a similar problem I can try my best to route them to the right way.