SAP Integration Update Part 2 – Crystal Reports for Enterprise and Hierarchies from SAP NetWeaver BW
SAP Integration Update Part 1 – Crystal Reports for Enterprise and SAP NetWeaver BW of updates I provided an overview on how you can establish a connection from Crystal Reports for Enterprise 4.0 towards your SAP NetWeaver BW system.
This time we are going to take a look how to create a hierarchical report with Crystal Reports for Enterprise 4.0
Now lets assume you already created the connection and you started Crystal Reports for Enterprise 4.0. So as our first step we do select the connection from our SAP BusinessObjects Enterprise system.
In the next step we are presented with the common query panel for the connection.
The query panel provides us access to all the underlying meta-data and allows us to create a query for our report.
Now lets focus for a second on the Country part shown in the image above. You might notice that we have “Country” and “Country Hierarchy 1”. “Country Hierarchy 1” is a hierarchy defined in SAP BW and we can incorporate the hierarchy into our data request.
“Country” is what is being called a default hierarchy and will be relevant for cases when hierarchy variables are involved so that you can use a default hierarchical definition and then at runtime switch between hierarchies.
Now for our example we use the Country Hierarchy 1 and the Net Value as part of our query definition.
Before we now go ahead and execute our data request we are opening up the member selector for our hierarchy.
The Member selector now provides us access to all the hierarchy nodes and leafs and we can select which parts of the hierarchy we would like to make part of our report.
For our example we continue with the selecting all the members of the hierarchy.
In the query panel we are then shown our selection before executing the actual request.
Now to the actual report design we are going to create a group as first step.
Those familiar with the hierarchical reporting in Crystal Reports 2008 will notice a big difference here. In Crystal Reports for Enterprise 4.0 there is no need anymore to define a parent child relationship as Crystal Reports for Enterprise 4.0 is able to recognize the hierarchy from the underlying connection. So in our group definition we define the group on our Country Hierarchy 1 and define an Group Indent of 0.3 inches.
As next step we are adding the field Net Value to our Group Header.
Look closely at the image above. Crystal Reports for Enterprise did not just drop the field Net Value to the Group Header but instead noticed that there is a hierarchical grouping involved based on a BEx query and therefore configured the total in the group header to become a “delegated” total.
“Delegated” means that the total is not being calculated by Crystal Reports for Enterprise but instead the totals are explicitly derived from the underlying backend system – in this case SAP NetWeaver BW.
Now after all that we are finished with our first report in Crystal Reports for Enterprise 4.0 with hierarchies from our SAP NetWeaver BW system.
In case you are more a “visual” person you can also follow me on iTunes here.