Merging 0WBS_ELEMT and 0PROG_POS Hierarchies in BW

[Former Member]

Dear All,

We have requirement to have one hierarchy in SAP BW which will be combined hierarchy from 0PROG_POS hierarchy and 0WBS_ELEMT.

Basically, I have two standard data sources in ECC that are giving me two hierarchies - one for 0PROG_POS and one for 0WBS_ELEMT. The example below shows the structure of two hierarchies:

• 0PROG_POS:

L1:  Investement Program I

L2: Investement Program I.A

L3: Investement Program I.A.1

• 0WBS_ELEMET

L1: WBS Element 1

L2: WBS Element 11

Using standard data source 0IM* I know that WBS Lement 1 is assigned to 0PROG_POS Investement Program I.A.1

How based on this information I can extend hierarchy based on 0WBS_ELEMT with higher nodes taken from 0PROG_POS hierarchy?

In other words - how can I achieve the hierarchy on WBS_ELEMT like this:

L1: Investement Program I

L2: Investement Program I.A

L3: Investement Program I.A.1

L4: WBS Element 1

L5: WBS Element 11

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

• The both hierarchies and assignements of WBS Elements to Investment Programs are changing through the year
• The upload of hierarchies (0PROG_POS and 0WBS_ELEMT) is done every week 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.

Cheers

Kasia

[Former Member]

Hi Kasia,

I am dealing with similar situation,  did you find any solution?

Regards,

Uzma