generic hierarchy extracor

[Former Member]

Hi,

does someone know how to create an generic extractor for hierachies?

The hierarchy is stored within a generic Table within an Oracle DBMS. I can access this table via DB-connect and I've created an extractor which is based on function module "RSSH_HIERARCHY_TRANSFER". I have to map the sourcesystem and an InfoObject to the BW-Hierarchy, but I don't know how. Within the simulation (RSA2 etc.) of the extractor just the first level will be displayed within the tree simulation. The table-simulation works well.

Thanks, Joerg

[Former Member]

Perhaps you could write something in R3 that would access the hierarchy in Oracle and this creating a set in R3. From there you could bring it into BW using a standard R3 hierarchy extractor