Skip to Content
author's profile photo Former Member
Former Member

non-standard Hierarchy

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 don’t have any standard Extractors available.

I don’t 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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 09:00 PM

    You need to write some code to fetch data from R/3 and then populate it in flat flat which should be recognized by BW and then you can upload it.

    Let me know if this helped.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 09:30 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 09:34 PM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.