Skip to Content
Author's profile photo Former Member

Custom Hierarchy Extraction in SAP BW 7.3 (Part2)

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.

Capture5.JPG

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

Capture6.JPG

Then data source will be generated and available in RSA6.

Capture7.JPG

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

Capture8.JPG

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.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo KONKA SREENIVASULU
      KONKA SREENIVASULU

      Hi Priya,

      Most Useful Documentation.. 🙂

      Regards,

      Sreeni

      Author's profile photo Former Member
      Former Member

      Hi Priva

      Very good document

      Thanks a lot

      Regards

      Rodrigue