Copy Hierarchy Structure from one Dimension to another dimension

[sap_user62]

Hello Friends

Env - BPC 10.1 standard NW

The Cost Center Dimension is populated by BW InfoObject (Attribute, text and hierarchy). Its used in Finance Model.

There is subset dimension of Cost Center, called Sender Dimension used in Allocation Model. Sender dimension has around 1/10 members of Cost Center dimension. Sender Dimension has a List hierarchy

Allocation Model has Cost Center dimension too and it stores receiving allocations.

New Req - Users want the ability to have the same hierarchy structure as Cost Center in Sender dimension so that analysis is done at a node level instead of base level senders. All the nodes would be same, but only the base senders are populated in the hierarchy. We can expect nodes which do not have any Senders to be childless

Tried to populate sender dimension hierarchy structure with Cost Center BW info object hierarchy and it failed. (skipped 0Costcenter in IOBJNM and populated only 0HIER_NODE)

Is there a way in BPC to copy the hierarchy nodes only from one dimension to another (structure)

Its fine with both the Cost Center and Sender have the same hierarchy node names.

Thanks for your time.

[former_member186338]

Sorry, but not clear!

How do you load members of Sender dimension?

Also from BW infoobject?

What is the hierarchy structure in BW?

And screenshots...

[sap_user62]

0costcenter (standard SAP Infoobject) in BW has a property(is_sender), which is flagged when a cost center is a sender.Sender dimension in BPC is populated from 0costcenter for flagged costcenters only. A list hierarchy (H1) is created for Sender dimension later. (using excel option).

Costcenter dimension is also populated using 0costcenter. (att,text,hier) - this works well.

structure of hierarchy table in bw

[former_member186338]

Some sample of hierarchy with sender and other members and some nodes?

[sap_user62]

Hierarchy attached. Not all the CC under Finance are allocated. Technology is almost 90% allocated and Executive functions are not allocated.

Sender dimension and Cost center dimension

[former_member186338 · Accepted solution]

Sorry for late answer!

You can load Sender dimension with the option "OR" for members and hierarchy