Symptom
- The crystal report is using Business Warehouse as the data source
- The hierarchy display is activated for the dimension object
- How to display dimension object hierarchically from crystal report
Environment
- SAP Crystal Reports (CR)
- SAP Business Warehouse (BW) 7.01
Resolution
- Open SAP BEx Query Designer to develop a query based on the Business Objects Customer cube.
- Drag dimension Country into the Columns section.
- Drag key figure Product Price into the Rows section.
- Select the Country dimension and from the properties page select Hierarchy tab.
- Select the hierarchy which you would like to activated.
- Save and export the query.
- Open crystal report and click the SAP menu button to create a new report.
- Switch to the Design tab.
- Click the Insert menu button and select Group.
- From the Common tab, select to group by Country Node ID.
- From the Options tab, select Customize Group Name Field and choose Country Name then click ok.
- Click the Report menu button and select Hierarchical Grouping Options.
- Select Sort Data Hierarchically and choose Country Parent Node ID for the Parent ID Field.
- Set Group Indent as 0.5 then click ok.
- Refresh the data, the Country dimension will display hierarchically.
Keywords
CR, 2008, SP3, hier, BW , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V1