User`s guide
How to create a simple BW query with a hierarchy
This section uses the query that you created in the last tutorial, Building a report off a BW query. You
will be adding a hierarchy to the query on the Material dimension.
To create a BW query with a hierarchy
1.
Go to Start > Programs > Business Explorer > Query Designer.
2.
Click Open Query.
3.
Select the query you created in the last tutorial.
If you have not created a query, see Building a report off a BW query.
4.
In the Rows area, right-click Material and click Properties.
The "Characteristic Properties" dialog box appears.
5.
Next to the Hierarchy Name field, click the Values button.
The "Select Hierarchy" dialog box appears.
6.
In the Available Hierarchies list, select Material class and click OK.
You are returned to the "Characteristic Properties " dialog box.
7.
Click OK and then click Save Query As... to save your query to the appropriate location.
For this example, in the Description field, type Simple Hierarchy for MDX, and in the Technical Name
field, type HIERARCHY_SIMPLE_MDX.
8.
Click Quit and Use Query.
You now have a simple query with three possible levels of hierarchy. You can display the query in either
the SAP Business Explorer Analyzer or as a dataset in Crystal Reports.
How to build a report off the BW hierarchy
The report that you build in this section starts using the same field as the report you created in Building
a report off a BW query. The difference comes with the grouping. Instead of grouping the data like you
did in the previous tutorial, you will group the data hierarchically. This way, the hierarchy that exists in
the data is reflected in the report.
This tutorial will use the following fields to create a hierarchical display:
• Hierarchy Name Node ID
This field reflects the child values.
• Hierarchy Name Parent ID
This field reflects the parent values. Combined with the Actual Node ID, Crystal Reports uses these
fields to determine the hierarchy based on the information received from the SAP BW query.
• Hierarchy Name
2012-03-14579
Integrating Business Applications with Crystal Reports