How to use Hierarchy in my reports

[Former Member]

I created a hierarchy structure (from a link in SDN) as below

ZSREP - This characteristic InfoObject has ZSCOUNTRY and ZSREGION as the external characteristics.

Then I created a DSO with ZSREP as the Key Field and ZSALES(Key Figure) as the Data Field, and loaded some sample data into the DSO and activated it.

I created a Query on my DSO and the report shows the data in tabular format. But how do I show the hierarchy in my report. Do I need to addd ZSCOUNTRY and ZSREGION also to the DSO and subsequently load data to it?

[Former Member · Accepted solution]

Hi,

You need to select the hierarchy for the characteristic in the report.

Select the char, in the properties pane, Hierachy tab, choose the hierarchy. Make sure the check box 'Activate Hier display' is selected.

[Former Member · Accepted solution]

Hi Murali,

Thank you very much. I never knew it would be that simple. I am very new to SAP BI. Nevertheless, thank you once again

Edited by: srsapbibw on Mar 1, 2011 11:50 AM