Custom Hierarchy Extraction in SAP BW 7.3 (Part2)

[Former Member]

System:

SAP BI 7.3, ECC 6.0

In my previous article, we have seen how to create a custom hierarchy in ECC.

http://scn.sap.com/docs/DOC-27510

Here we talk about how to create a Generic hierarchy data source to extract this custom hierarchy in ECC.

To create a generic hierarchy datasource for the set hierarchy created using GS01,

goto the t-code BW07.

Since the hierarchy is based on company code, choose the table T001 and field as BUKRS.

And give the name of the data source, and execute. Below pop up appears. Press YES.

Then data source will be generated and available in RSA6.

The custom hierarchy exatraction using this data source can be tested in RSA3.

And this data source has to be replicated and activated in BW.

Next step is to create hierarchy transformation from this data source to the info object.