Hi all,
I have 0country and a hierarchy on it.It is like World
>Continens
>Countries . I want to see the sales of a continent which is asked to user i.e I want to restrict the key figure revenue with the continent that will be asked to the user.So I tried to create hierarchy node variable.However, query designer does not allow me to restrict a KEY FIGURE with hierarchy node variable(It claims that I am using the variable incorrectly)
Then I tried to restrict it with a hierarchy variable(not node variable) But I can not select the hierarchy variable when I try to restrict the key figure.It only displays characteristic value variable and hierarchy node variable in the variable restriction screen.Not hierarchy variables.
To sum up: How can I restrict a key figure with a node in the hierarchy i.e how can I see the sales of a continent
Regards,
Sunny