Skip to Content
0
May 03, 2017 at 09:19 AM

Merge Hierarchies in BW

268 Views Last edit May 03, 2017 at 02:00 PM 2 rev

Dear All,

We have the requirement to build one hierarchy in SAP BW which will combine a hierarchy for Cost center hierarchy and a hierarchy for WBS Element.

Basically, we have two standard data sources in ERP that are giving me the two hierarchies - one for Cost center hierarchy and one for WBS Element.

Can somebody help me with this requirement? Same question can be found here:

https://archive.sap.com/discussions/thread/3710811

Please note that this should be at least semi automated solution as:

  • The both hierarchies are changing through the year
  • The upload of hierarchies is done every day and joining them should be a step in proces chain.
  • The combined hierarchy will be automatically transferred to BPC.

Your help will be much appreciated.

Regards

Gilles