Questions on MUN.

[Manu0521]

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,

[MFGF]

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.