How to load values of nodes in hierarchy to other dso

[former_member510577]

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

Orit.

בברכה,

אורית.

[former_member186399 · Accepted solution]

Hello Orit

Is the hierarchy the only way out for you ?

You can make company and region as an attributes of cost center . By this you can control the data loading from one DSO to another.

Regards

Gajesh

[former_member510577 · Accepted solution]

UNfortunately,we dont have company and region like a field in ecc - Only like nodes of the hierarchies..

WE have many hierarchies of fund centers and cost elements and others but in Bw we have requirment to build organization structures company and region.We must to transfer nodes of hierarchie to fields attribute in bw.

[former_member186399 · Accepted solution]

Hello,

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.

Regards

Gajesh