Author Bio: Sanchit is an Associate Software Engineer in Accenture Services Private Limited. He has been involved in SAP BW Implementation Projects.

Business Scenario:

The standard hierarchy datasource provides hierarchies in the SAP BI system in the Hierarchy format, but sometimes we need the hierarchies in the flat structure as per the business requirements, e.g. to support other reporting interfaces or incase we need specific level objects to be explicitly used. The Hierarchy is in the form a nodes/Folders structure which can be flatenned with all its levels.

Illustration:

The following steps illustrate how the above mentioned workaround can be utilized.

In our case, we will be using the InfoObject 0PROFIT_CTR for flattening its defined levels.

Pre-requisites:

We need to have pre-defined levels of the hierarchy and the Hierarchy should be already uploaded and acitvated for the corresponding InfoObject (e.g. 0PROFIT_CTR).

This is very helpful. Do you also have an example of how to attach the Master data text to your custom Info Objects (ZLEVEL1 – ZLEVEL7)? I’d like to get the Short, Medium and Long text but don’t know where to pull from. I’m assuming that I’d setup a Master Data Text Transformation with custom code in the End Routine and query the RSTHIERNODE table.