Prompt values not populating

Question

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

Johan (South Africa) · Answer

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.

Joel Acha · Answer

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

Johan (South Africa) · Answer

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.