Skip to Content
author's profile photo Former Member
Former Member

Restricting with Hierarchy (node)Variable

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 12, 2011 at 10:21 AM

    Hi,

    Step 1: Create a Hierarchy variable

    Step 2: Select the required single value in variable screen

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Suman,

      As I told, I have already done what you have said and when I do that the warning says "The variable ZVar_0country is not available or not used correctly" when I try to restrict the key figure with the hierarchy node variable.

      And when I try to restrict the key figure with the hierarchy variable, it does not appear in the restriction screen, only node variables are displayed so I can not restrict 0country with a hierarchy variable.

      I started to think that these types of variables are only used for displaying, not filtering the data.

  • Posted on Dec 12, 2011 at 10:23 AM

    Hi,

    Please check out this link.

    variable hierarchy doesn't work

    It might be helpful for you.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.