1) For example consider my dimension product has 4 levels.
level1 - All the product teams
level 2 -Individual teams
level3 - products under individual teams
Now I wanted to have a prompt which shows all teams,individual teams
I create a query calculation and add the all team member and then add children (all team member) and set the default selection of prompt to all team members mun value.
Now i run the prompt and the values are populated.
Now my main query will have a filter like level1-? the prompt name i created.
when I change the prompt value to an individiual team now , i get an error since the values is from a different level that is level 2.
How should the filter condition be ? when doing union on parent and child from different levels but same dimension.
Thanks,
Quote from: Manu0521 on 09 Apr 2014 01:48:01 PM
1) For example consider my dimension product has 4 levels.
level1 - All the product teams
level 2 -Individual teams
level3 - products under individual teams
Now I wanted to have a prompt which shows all teams,individual teams
I create a query calculation and add the all team member and then add children (all team member) and set the default selection of prompt to all team members mun value.
Now i run the prompt and the values are populated.
Now my main query will have a filter like level1-? the prompt name i created.
when I change the prompt value to an individiual team now , i get an error since the values is from a different level that is level 2.
How should the filter condition be ? when doing union on parent and child from different levels but same dimension.
Thanks,
Hi,
No - don't use filters in your report - using filters in a dimensional report is a very bad thing!
Instead, use a query calculation in your crosstab with the expression [Your hierarchy] -> ?PromptParameter?
This will accept members selected from any level of the hierarchy in your prompt.
MF.