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

Prompt values not populating

Received Response
32
Views
6
Comments
Johan (South Africa)
Johan (South Africa) Rank 3 - Community Apprentice
edited Aug 13, 2024 5:25PM in Oracle Analytics Cloud and Server

Hi everyone

When we edit or create a new dashboard prompt (column prompt) we can add the "Choice List Values" but when we want to select specific default values the members do not load in both panels on the left (Heading = "Available") and right (Heading = "Selected"). The following message is displayed: "Loading..." but no members are displayed.

Has someone experienced this before and have a possible solution at hand.

We have reloaded metadata and cleared cache and restarted both the BI Server and Presentation Services components but this does not resolve the issue.

Thanks

Johan

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Can you create a test analysis with just this column that you're using for the dashboard prompt to see what happens? How many rows does it return? How many distinct rows?

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    Hi Joel

    I have created a new dashboard prompt and only added one column prompt. I add 3 members in the Choice List Values section and when I go to Default Selcetion and selecte Specific Values and then try to expand the hierarchy on the left (Available pane) it does not expand.

    Regards

    Johan

  • Joel
    Joel Rank 8 - Analytics Strategist

    As mentioned, can you create an analysis with this column only? How many records does this return in the analysis? The rationale behind this is to see if OBIEE actually returns the data properly before delving into the issues with the prompt.

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    I created an analysis of this hierarchy column. The first parent that I am attempting to expand and not showing anything has 11 children. The total list of this specific hierarchy has 811 members.

  • Joel
    Joel Rank 8 - Analytics Strategist

    So not a data volume issue then. Have you tried clearing browser cache? Have you tried this on another browser?

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    I have BI Server and Presentation Services and reloaded metadata. I have also tried this in Microsoft Edge and Firefox and this issue still occurs.