how to reset data dynamically in dashboard prompts without clicking on reset button in obiee 12c? — Oracle Analytics

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

how to reset data dynamically in dashboard prompts without clicking on reset button in obiee 12c?

Received Response
22
Views
11
Comments
DollyG
DollyG Rank 5 - Community Champion
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

I have 3 dashboard prompts having dependent values. Product list values are displayed based on BU selected and Application list values are selected based on Product.

Suppose I select BU as 'Central'. Products related to Central are displayed in Products dropdown, select say 'ATOM' and the result is displayed.

Central_ATOM.PNG

Now, I chose BU as 'APAC', at this moment, 'ATOM' should have been disappeared from Products dropdown as this is the product of a different BU and the products of APAC should be displayed. But, ATOM is still visible in Products dropdown, and I get 'No Data Present' which is wrong.

APAC_ATOM.PNG

Can anyone please help me how to resolve this error, that product and application prompt are dynamically reset while a BU value is changed?

«1

Answers

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

    a) are those columns in a hierarchy?

    b) are they dependent on all prompts or just specific ones?

  • DollyG
    DollyG Rank 5 - Community Champion

    There are no hierarchies. These are 3 different columns of a single table. Also,

    Product prompt depends on BU and Application prompt depends o BU and Product.

    For eg, for any BU(Business Unit) contains multiple products, and each of those products contain multiple applications.

  • DollyG
    DollyG Rank 5 - Community Champion

    It would be of great help if anyone could guide me on this.

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Do you have this enabled?

    pastedImage_0.png

    If not, which version are you using of Oracle-BI?

  • DollyG
    DollyG Rank 5 - Community Champion

    Hi Michael,

    I am using a different approach, instead of all column values, I am using 'SQL Results'.

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

    facepalm...

    Circumvent the normal functioning of the tool and you get funny behaviour.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    DollyG wrote:I am using a different approach, instead of all column values, I am using 'SQL Results'.

    Hi,

    As you are not using what the product provides as functionality you can't expect to have a feature allowing you to fix the issues you got when not using the product functionalities.

    As soon as you move into "SQL results" prompts you can't really expect to have simple connected things anymore.

  • 3195949
    3195949 Rank 3 - Community Apprentice

    Dolly,  Instead of using Limit values by 'All Prompts', check mark each individual prompt even though you're selecting all. I have seen All Prompts not working the way it should do, l'm thinking this might be your issue. Just try and see how that goes.

  • Gianni Ceresa
    Gianni Ceresa Mod

    When a prompt column is set to "SQL Results" instead of "All Column Values" you don't have the "Limits values by" option at all.

  • DollyG
    DollyG Rank 5 - Community Champion

    Hi,

    It does not work this way. I have tried it. Any other alternative?