Restricting Characteristics: Hierarchies

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
  Tip

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

• Variable Hierarchy Node - Fixed Hierarchy
  Tip

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

• Fixed Hierarchy Node - Variable Hierarchy
  Tip

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

• Variable Hierarchy Node - Variable Hierarchy
  Tip

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

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

For more information about hierarchies, seeHierarchies.

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 underTypein 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 (seeSelecting 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 Hierarchyin 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 (seeSelecting 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 underTypein 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 (seeSelecting Hierarchies).
6. Add the selection to the right Selection window using the right arrow.

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.