User`s guide

5.
Ensure that the Selection field is set to Single Values, and that the Hierarchy field is set to the
hierarchy you created for this dimension.
In this example, the hierarchy is Material class.
6.
Click the Variable tab.
7.
Right-click in the white space and click New Variable.
The SAP BW Variables Wizard opens.
8.
Click Next on the Introduction window.
9.
Ensure that the Type of Variable field says Hierarchy Node.
10.
Fill in the rest of the fields as follows:
• In the Variable Name field, type a name such as HNV01.
• In the Variable Description field, type a name such as Test Hierarchy Node Variable.
• In the Processing by field, ensure it says User Entry/Default Value.
• In the Characteristic field, ensure it says Material.
11.
Click Next.
The Details window appears.
12.
On the Variable Entry is list click Optional or Mandatory.
13.
Click Next to accept the other default values.
The "Default Values" window appears.
14.
Click Next to accept the default values.
15.
Click Finish to create the variable.
You are returned to the "Selection for Dimension" dialog box. Your new hierarchy node variable is
visible in the variable list.
To add the hierarchy node variable to the query
1.
Click the hierarchy node variable named Test Hierarchy Node Variable.
2.
Click the right arrow to move the variable to the Selection area of the dialog box.
3.
Click OK.
You are returned to the BEx Query Designer. Your new hierarchy node variable is visible in the
Rows area under the Material characteristic. You are now ready to save the query.
4.
Click Save Query As.... to save the query with a new name and description.
For this example, in the Description field, type Simple Hierarchy w Node Variable, and in the Technical
Name field, type HIERARCHY_SIMPLE_HNV.
5.
Click Quit and Use Query.
2012-03-14583
Integrating Business Applications with Crystal Reports