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

How to load sets from R3 to BW

In R3, we have many report painter reports which were written using various account sets and cost center sets, etc. These sets were created in t-code GS01, and they can contain one single node or multiple nodes.

We are activating various BW cubes and loading all data from R3 into the appropriate cubes. We noticed that none of the sets we use in our R3 reports are in BW. Even R3 sets that are created in KDH1, for example, if the set only contain a group of accounts (and no multiple nodes), they don't show up in BW.

We know that standard BW can accept 'hierarchies', but most of our sets are not true 'hierarchies', and we cannot create hierarchies for them because some of the nodes will have overlapping/repeating values.

Is there a way we can extract the R3 sets and load it into BW? We do not want to maintain the sets manually in BW. Users will change these sets in R3 and we want the ability to automatically load those changes into BW.

We are currently on R3 - ECC 5.0, and NetWeaver BI 7.0.

thank you,


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 19, 2007 at 08:19 PM

    Have you found a solution? I think I have some information on this but it would take awhile to dig up?

    Let me know.


    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.