Skip to Content
0
Dec 12, 2011 at 09:20 AM

Restricting with Hierarchy (node)Variable

232 Views

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