I have a custom table having funds Group ,Funds & funds Center in R/3.
Funds Grp is the collection of some funds & every fund contains couple of Fund Centers below it .
In BW , we need a Hierarchy like :
Funds Group 1
Fund 1
Fund Center 1
Fund Center 2
Fund 2
Fund Center 3
Fund Center 4
Funds Group 2
Fund 3
Fund Center 5
Fund Center 6
Fund Center 7
Can you suggest me : How can I create a datasource on this & pull it in BW as hierarchy ????
Since this is not a standard hierarchy, I dont have any standard Extractors available.
I dont want to build it in BW manually since we have lots of Funds & fund centers & also they change very often so cant be maintained .
Thanks,
Shalini
Hi Shalini,
There is something called as "CTBW"(tcode is CTBW) configuration which can be used for tranporting hierarchies to BW. I have used this for Functional location classifications(hierarchies). Iam not sure whether you can use this for Funds hierarchies. Maybe you can do a little research with this.
Saikrishna
I have a document(i have to do some searching though) regarding how to configure these classifications(hierarchies) first in SAP R/3 and then replication and extraction of the datasources and data in BW. Send me a test mail at saikrishnak@gmail.com if you need this info
Saikrishna
Add a comment