Restricting Characteristics: Hierarchies 

Use

In the Query Designer, you can restrict characteristics by hierarchy or hierarchy node, on a fixed or variable basis.

You can choose from the following options:

●      Fixed Hierarchy Node – Fixed Hierarchy

Report on department A (fixed hierarchy node) for the hierarchy valid for 2005 (fixed hierarchy)

●      Variable Hierarchy Node – Fixed Hierarchy

Report on chosen department (variable hierarchy node) for the hierarchy valid for 2005 (fixed hierarchy)

●      Fixed Hierarchy Node – Variable Hierarchy

Report on department A (fixed hierarchy node) for the hierarchy valid for the current calendar year (variable hierarchy).

●      Variable Hierarchy Node – Variable Hierarchy

Report on a chosen department (variable hierarchy node) for the hierarchy valid for the current calendar year (variable hierarchy).

Prerequisites

This function is only available if hierarchies exist for the characteristic that you want to restrict.

For more information about hierarchies, see Hierarchies.

Procedure

Fixed Hierarchy – Select Fixed Hierarchy Node

...

...

       1.      Choose Show → Single Values.

       2.      Choose the required hierarchy under Hierarchy.

       3.      Navigate to the required hierarchy node in the hierarchy tree.

       4.      Select the required hierarchy node and copy it to the right Selection window using the right arrow.

Fixed Hierarchy – Select Variable Hierarchy Node

...

...

       1.      Choose Show → Variables.

       2.         For the selection of the variable hierarchy node, choose Hierarchy Node Variable under Type in the upper area.

       3.      From the list of available hierarchy node variables, choose the required variable and select it.

       4.      In the lower area, under Hierarchy, choose . The Select Hierarchy dialog box appears.

       5.      Select a fixed hierarchy (see Selecting Hierarchies).

       6.      Add the selection to the right Selection window using the right arrow.

Variable Hierarchy – Select Fixed Hierarchy Node

...

...

...

       1.      Choose Show → Single Value.

       2.      For the selection of the fixed hierarchy node, choose the required hierarchy under Hierarchy in the upper area.

       3.      Navigate to the required hierarchy node in the hierarchy tree and select it.

       4.      In the lower area, choose Variable Hierarchy.

       5.      Choose . The Select Hierarchy dialog box appears.

       6.      Select a variable hierarchy (see Selecting Hierarchies).

       7.      Add the selection to the right Selection window using the right arrow.

Variable Hierarchy – Select Variable Hierarchy Node

...

       1.      Choose Show → Variables.

       2.      For the selection of the variable hierarchy node, choose Hierarchy Node Variable under Type in the upper area.

       3.      From the list of available hierarchy node variables, choose the required variable and select it.

       4.      In the lower area, under Hierarchy, choose . The Select Hierarchy dialog box appears.

       5.      Select a variable hierarchy (see Selecting Hierarchies).

       6.      Add the selection to the right Selection window using the right arrow.

...

...

Result

You have restricted a characteristic according to a node within a hierarchy. Choose OK. This takes you back to the Query Designer. Save your entries and execute the query.

If you have restricted a characteristic to a variable hierarchy or a hierarchy node, before the query is executed a dialog box appears in which you manually enter variable values (provided that the variable is flagged as Ready for Input). Enter the required values and choose OK. The query can now be executed with the values you selected to fill the variable.