Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Dashboard prompts and analysis level prompts

Received Response
21
Views
4
Comments
3427784
3427784 Rank 4 - Community Specialist
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    3427784 Rank 4 - Community Specialist

    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]
    [Deleted User] Rank 2 - Community Beginner 
    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
    3427784 Rank 4 - Community Specialist

    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.