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

Hierarchy load from R3 to BW

Hi,

I have a datasource for an InfoObject and would want to retrieve the data from this datasource somehow and upload or transfer the data to BW into a hierarchy. How would I approach this? Is there a way to have BW retrieve it directly?

Thanks,

RT

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 06:28 AM
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 06:53 AM

    Hello Rob,

    if you have maintained hierarchy on the R/3 side, only then can you use the hierarchy datasource and have it as a hierarchy on the Bw side.

    if you dont have a hierarchy datasoure, the normal data from R/3 side will never come as hierarchy on the BW side.

    You can go ahead and maintain hierarchy in the hierarchy tab of the infobject ->change screen.

    Also check out the display as hierarchy option in the query designer. In the rows section, right click on the top and use this option.

    Hope this helps..

    thanks,

    Add comment
    10|10000 characters needed characters exceeded