Add Hierarchy to dashboard prompt — 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

Add Hierarchy to dashboard prompt

Received Response
11
Views
7
Comments
choracy69
choracy69 Rank 6 - Analytics Lead
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hi,

I have some question

I created analysis:

pastedImage_0.png

And add filters:

pastedImage_1.png

And I add Purchasing Category Hierarchy to dashboard prompt:

pastedImage_2.png

But when I open a dashboard, and choose some option in prompt, for example:

pastedImage_3.png

Nothing happens:

pastedImage_4.png

Do I need something extra set or whether there is even an option to use a hierarchy in prompt?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    When using a hierarchy as prompt you don't filter the analysis by setting "is prompted" on all the levels but you add the hierarchy to the analysis as well and using selection steps you define it can be override by the prompt.

    Capture.PNG

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Ok, I understand and it's working.

    But I have another question.

    When I turn on the prompt in going value, eg: Semi (level 1) - Trans (level2) - Other (level 3), where a semi is the highest level and the other lower. That's when choosing Other analysis shows me all the values of the Other for other top level. This should not be such that a specific group chooses me for the Semi-> for Trans> for the Other?


    Example:


    Good results when I don't use the prompt.

    pastedImage_2.png


    Use prompt:

    pastedImage_0.pngor pastedImage_3.png

    Results:

    pastedImage_4.png or pastedImage_5.png

    Can not do to the value of the prompcie was not so: Semiconduc; Transistor; Other just for example this: Semiconduc.Transistor.Other?

  • Gianni Ceresa
    Gianni Ceresa Mod

    It's a bit confusing ....

    So the correct value of "Semiconduc" > "Transistor" > "Other" is 2'032'632.

    But when you filter with your hierarchy in the prompt on "Semiconduc" > "Transistor" > "Other" you have "Other" > "OTHER" > "Other" appearing on screen instead of "Other" below "Transistor" ?

    If that's why happen, are you sure about the logical keys your defined in your hierarchies?

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Gianni, thanks for response.

    Yes, the correct value is 2,032,632.

    But when I choose the prompts Semiconduc-> Transistor -> Other (ie other level 3) it appears to me all kinds of other not dependent on Level 1 and 2.

    Maybe it's because after the election of the structure in the prompt, record looks like this:

    pastedImage_0.png

    I think that my logical keys it's good.

    I have something like:

    pastedImage_1.png

    And simple settings:

    pastedImage_2.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    What is the value of Dim - Item.Purchasing Category Hierarchy 8 for the Semiconduc > Transistor > Other rows ?

    Is it maybe "Other" ?

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Dim - Item.Purchasing Category Hierarchy 8 is a ID, and the Dim - Item.Purchasing Category Hierarchy 8 Name is a lookup table.

    "Other" is only from level 3,4...

    Top level: Semiconduc

    8: Tranzistor..

    7: Other..

    Good value with using hierarchy (without prompt):

    pastedImage_0.png

    And when I use columns: Top Level, level 8, level 7:

    pastedImage_1.png

    The results agree.

    It does not work just the same drill to a designated Level.

    I thought maybe I marked "skipped level" but also in the structure is all good.


    I know that I can create seperate column prompt for each level and it works well, but it is not very intuitive solution.

  • Gianni Ceresa
    Gianni Ceresa Mod

    I couldn't find an hierarchy like yours with the same value for different branch of the hierarchy so I couldn't try the exact case to see if there is a bug or something.

    So I stay on my first impression: that there is a key somewhere not defined in a way to uniquely identify the correct "Other" value in the right branch.

    Do you have the issue with wrong number when selecting other elements of the hierarchy in the prompt or only on "Other" ?

    Any other value repeated for 2 different parents you can try?

    If you have a look at the physical query and you check where it select the wrong "Other" don't you also see there around the logical key you defined that maybe require some more work to make it really unique in the whole hierarchy?