Variable Hierarchy and Node Hierarchy

[Former Member]

Hi Gurus,

Would like to ask for your assistance regarding the settings in the query that I need to modify. Below is the scenario

-There are 4 active hierarchy in the master data, hier1, hier2, hier3 and hier4

-The need is to have 2 variable for this hierarchy in the report

-one variable is to select the one of the 4 active hierarchy

-second intiial screen variable is the nodes or contents of the selected hierarchy above.

i think this is exit but can you give me adive on the execution of this.

[cornelia_lezoch · Accepted solution]

Hi,

what is the problem?

The first requirement is a hierarchy variable, the second is a hierarchy node variable.

These are standard variables which can be created in query designer.

regards

Cornelia

[Former Member · Accepted solution]

Hi Cornelia,

Thank you for your reply. The requirement is I should select an active hierarchy in the first hierarchy variable, the second variable is the node hierarchy that depends on the selection of active hierarchy on the first.

sample

1. variable hierarchy ( drill down )

hier1

hier2

hiere3

hier4

After selecting from the 4 active hierarchy above

2. node variable ( the node values here depends on the selection on the first variable ) i f you select hier1 above, the second node outputs the value from the hier1, if you choose hier2, the nodes from hier2 will populate, and so on.

[cornelia_lezoch · Accepted solution]

Hi Ethan,

yes, this is what the variable do without any programming.

you will need the hierarchy node variable only if you want to select special nodes out of your hierarchy. If you want to select all nodes from the heirarchy you don´t even need to use a node variable.

Just make sure, when you do the selection in your query filter, that you select the hierarchy variable and if necessary the node variable as well.

regards

Cornelia

[Former Member · Accepted solution]

Hi Cornelia,

There are 4 active hierarchy set, this could be selected thru a hierarchy variable with drill down.

But for the node variable, I think in order to have a node varaible, you will select a specific hierarchy set that will be available in the prompt screen. How will this be changed if I want to select the node of the hier1, or hier2 or hier 3 or hier4 if in the query settings I chose hier1 as default hierarchy set.

I need to filter selected nodes in 4 hierarchies in the initial screen.

Thanks for your help on this

[cornelia_lezoch · Accepted solution]

Hi Ethan,

this is your error :

" if in the query settings I chose hier1 as default hierarchy set."

you dn´t choose the hier 1 as default in your query, you choose the hierarchy variable.

[Former Member · Accepted solution]

Hi Cornelia,

That setting is what I am saying. The variable hierarchy that I will indicate there in your blue cirle is the drill down hierarchy, the 4 active hierarchy. How will I choose the node level of each of the hierarchy in just one initial variable filter?

Thank for for your continous help

[Former Member · Accepted solution]

Hi Cornelia,

Is there a way I could see all the node variables of all 4 hierarchy in just one selection screen?

the first variable shows the 4 active hierarchy with drill down

the second variable screen will show the per node of all the 4 active hierarchy, or if there are 5, 5 active hierarchy

the nodes are searchable

[cornelia_lezoch · Accepted solution]

Hi Ethan,

you can only create selection which combine one hierarchy variable with one hierarchy node variable.

If you want to select nodes from several hierarchies, you need to create as many sets of hierarchy and hierarchy node variables as you want / need.

The system will probably give a warning message, but it will work.

regards

Cornelia

[Former Member · Accepted solution]

Hi Cornelia,

The request wants to have a 2 variable, one is to select the hierarchy set, then after selecting the hierarchy set, the second variable selects the node on the hierarchy on the first.

I tried creating 4 hierarchy variable for earch hierarchy set but it is not the requirement.