Skip to Content

How to merge hierarchies in SAP BW

Hello,

I have a requirement, I have to merge tow hierarchies in SAP BW comming from different sources, can any one give me a hint ?

Kind Regards

Anis

Add comment
10|10000 characters needed characters exceeded

  • Hello,

    I have tried loading the hierarchies one by one to a DSO and merging them to the existing one in DSO, the problem is that my example works for small hierachies but when it comes to big ones it does not generate the good child_id, next_id or parent_id, is there any way to calculate these fields automaticly while merging the hierarchies ?

    I apreciate your help.

    Kind Regards

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 21, 2017 at 03:56 PM

    I did this by writing a program. The starting point is function module RSNDI_SHIE_STRUCTURE_GETn, where n is the highest number of this function module in your system.

    The end points is function modules RSNDI_SHIE_STRUCTURE_UPDATEn and RSNDI_SHIE_ACTIVATE.

    You should also consider methods copy and check_and_activate of the class cl_rssh_hierarchy_func.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18 at 10:28 AM

    Hello Methiew,

    I have done this using an other method if this is interesting for you, the key for this is to save the name of the parent, first child and next_id in the DSO before changing the ID of the node it self, once we change the id to add other hierarchies, we get the new ID using the name.

    Kind Regards

    Add comment
    10|10000 characters needed characters exceeded