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
  • Variable Hierarchy Node - Fixed Hierarchy
  • Fixed Hierarchy Node - Variable Hierarchy
  • Variable Hierarchy Node - Variable Hierarchy

Prerequisites

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

For more information about hierarchies, seeHierarchies.

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 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.

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.