Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to load values of nodes in hierarchy to other dso

Dear friends!

I have bex on dso with dimension hierarchy of cost centers and measure income. for example,

Company                      20000

---region.                      20000

------costcenter1.        5000 

------costcenter2.        5000

------costcenter3.        10000

the region and company is node of hierarchy.

We have other dso Bsc with dimension of organization init:company and region.

I need to load the income of company,region to dso bsc. We want to get values of the nodes in hierarchy.

for example,

company 20000

region 20000

We try using apd but apd doesnt work with hierarchy.

there is option transformation from dso to dso but it seems complex.

What is best way to do it?

Best regards




Former Member


Another option can loading from one DSO to another. When you load  the data make use of the hierarchy table and fetch up the corresponding company and region of the cost center. You can use the Parentid and childid  feidl from the hierarchy table to derive this.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question