Question:
hi,
i am having a Z table in sap R/3 and i need to buld a generic datasource of type hierrachy and load this hierarchy into my custom infoobject in BW.
can any tell me how to do this.
Thanks,
Ram
Answer:
Hi,
you have to load customer hierarchies as flat files - SAP does not provide hierarchy type datasources (you see that this is missing in RSO2). You need to write an ABAP which will create a flat file and then load this flat file to your infoobject. You can start by creating a full extractor which loads your Z table to an ODS in BW, followed by an ABAP to create the flat file based on the ODS, and then the load to the hierarchy.
Sandy
_________________
Sandy