In a dashboard, there is a prompt which contains 2 hierarchy prompts and there are two graphical reports which contain one of these hierarchies each.
But the requirement is to prompt both the reports based on these 2 prompts.
The problem is, when both the hierarchies are pulled into the report, the graph is getting split on the other hierarchy value also which is not desired.
Tried to place the other hierarchy in excluded section in which case it is not prompting for the one excluded.
For one hierarchy only, using selection steps it is solved. When both are needed to be prompted, there is a problem.
Have you tried to create two different analysis but with same prompts in the criteria section? When you build your dashboard you can just share the prompt and drag the two analysis onto the dashboard