Generic DataSource for Hierarchy

[Former Member]

Hi All,

I need to create a generic datasource for Hierarchy using Extraction from Table .Before starting the development, I would like to know what are the steps do I need to consider for creating a hierarchy strucuture. Base table will contain only 2 fields (Product hierarchy and Group).

Strucuture of the hierarchh should be same like 0PROD_HIER_TEXT.

Kindly let me know if anyone has done this before.

Thanks for your time.

Thanks & Regards,

Raja

[ChandranGanesan]

Hello,

See this

Thanks

Chandran

[ravikanth_indurthi]

Hi,

Initially identify the table in source system in generic extraction use the normal procedure to built the Generic extractor using tables.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/bi/generic%2bextraction

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d3219af2-0c01-0010-71ac-dbb4356c...

Generic Delta:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b062adbb...

Replicate the datasource in BW side and built the hierarchy to the required infoobject.

Assign the generic extractor and load the hierarchy.

Hierarchy extractor:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20a709c1-0a8e-2a10-21b4-f779728c...

Hope this helps.............

Rgs,

I.R.K

[Former Member]

Hi,

As a standard SAP Practice you can't create Generic datasources to load hierarchies from Source system.

In RSO2 u can check SAP provided options to create Transaction data, Attributes and text data data sources only.

Assign points if helpful.