This document will guide through the steps involved in building the hierarchy in Webi Report in tree structure or BI hierarchical layout model.

Introduction

The requirement is client may require display of Hierarchical structure (tree model) in Webi Report both in report output and selection parameters (prompt screen). This feature is not easy to achieve in 3.x version of BO.

In 3.x, there is a need of building universe and hierarchy in cascading format and pull up in the Webi Report.

But SAP has made it simpler in BI 4.0 and later version via BICS connection.

Pre-requisites

  1. BI 4.0 or later version of SAP Business Objects tools.
  2. BEx query with Hierarchy & Hierarchy Node Variable.
  3. BICS connection to the BEx query

Detailed Steps

Step 1> Create a Hierarchy based on the requirement.

For ex: below is the example of a Region Hierarchy.

Hierarchy - 1.jpg

As this is the requirement to be displayed this hierarchical format in selection parameters and report output. Now, go to step 2.


Step 2> Create a BEx query on the top of the Infoprovider (Mutilcube/DSO/Cube) where this hierarchy is involved.


Step 3> Select the hierarchy for the infoobject where the hierarchy built/loaded.

In properties select “Expand to Level” as maximum as possible.

Hierarchy - 2.jpg

The above step 3 will provide the display of hierarchy in Webi report output.


Step 4> In order to display hierarchical structure in Selection Parameter (prompt) of Webi Report, “Hierarchy Node Variable” has to be created.

Hierarchy - 3.jpg

Hierarchy - 4.jpg

Paremeters as below (Mandatory):

Below properties are mandatorily should be the same.

Hierarchy - 5.jpg

The below properties is based on your requirement.

Hierarchy - 6.jpg

Step 5> Once query building is finished, “SAVE” the BEx Query and run in RSRT (T-code) in BW or BEx Analyzer.

BEx query variable screen and output should display as below.


Variable Screen:

Hierarchy - 7.jpg

Output:

Hierarchy - 8.jpg

The same result should be shown in Webi report.

Step 6> Launch Webi Rich Client and after login in to enterprise server click on new report button “Hierarchy - 10.jpg” and select Bex.

Hierarchy - 9.jpg


Hierarchy - 11.jpg


Now select the BEx query created, earlier in Step 2, 3, 4 and 5.

Hierarchy - 12.jpg

Step 7> After clicking OK, Webi tool will take you to the “Query Panel”.

Hierarchy - 13.jpg

Drag the hierarchy which was earlier activated in BEx query and required fields and click on Run Query “Hierarchy - 14.jpg”.

Then Webi Report Selection Parameters (Prompt) screen will be displayed same as the BEx query variable screen as per the requirement.

Hierarchy - 15.jpg


Select all mandatory paramerters and run the report.

Then the same way webi report output is also displayed.


Hierarchy - 16.jpg


Conclusion:

Based on the above steps we can achieve the hierarchical structure (tree structure) display of hierarchy in Webi Reports via BICS connection.


Kindly provide your valuable feedback.


Other documents from my knowledge base.


A step by step guide for Invoicing Extraction (FI-CA)

Triggering Process chain after completion of ECC Delta Extraction Job

Golden rules/Tips & Tricks for BW/BI Designing

Automation of the Data Load from SAP R/3 to BI

Design Solutions for BI/BOBJ Reporting (Part 1)

Scheduling FI-CA related Delta Extraction


To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Lisa Herold

    Thanks for sharing but is it possible to flip the display of the hierarchy in Webi.  It seems in analysis we are able to but can’t find a way in Webi to flip the display of the hierarchy.

    (0) 

Leave a Reply