How to load values of nodes in hierarchy to other dso
I have bex on dso with dimension hierarchy of cost centers and measure income. for example,
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.
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?
Gajesh Nagesh replied
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.