Delete and Rebuild Hierarchy structure

[Former Member]

Hi Gurus,

We have production issue and this has been escalated because of business/production problems. We have hierarchy which gets loaded from ECC to BW on daily basis as Full load via infopackage to PSA and than in DTP we set extraction mode as Full load, enabled Only retrieve last request checkbox and in update method enabled Update Subtree radio button and Activate Hierarchy checkbox.

In ECC, users can change hierarchy structure or delete hierarchy nodes either child or parent. Recently user has deleted parent node and moved child to another parent when I extract data from ECC to BW, till PSA data load works fine while loading data from PSA to DTP data load fails with error message:

Node ID 00001234 has not been included as a sibling node or as a child node

5 of a total of 20,359 nodes are not included in the hierarchy

For ex: Before change hierarchy structure is

1.a-->1.a.1(Child for 1.a)-->1.a.1.1(Child for 1.a.1)

1.a-->1.a.2(Child for 1.a)-->1.a.2.1(Child for 1.a.2)

After changes hierarchy structure

1.a-->1.a.2(Child for 1.a)-->1.a.1.1 and 1.a.2.1(Child for 1.a.2).... 1.a.1 node is deleted.

This is production issue and business has stopped working and your help is very valuable. My user wants me to delete old hierarchy structure and rebuild hierarchy with new structure. I have tried all options like above DTP settings and please explain in detail. Gurantee of points for valuable answer.

Thanks,

Vaishu

[Former Member]

Hi Gurus,

I have deleted hierarchy manually by transaction code RSH1-->Delete and using Function Module RSSH_HIERARCHY_DELETE after that I cannot load hierarchy. Now because of this none of the reports display data as all BW queries are restricted/rows contain this hierarchy. After deletion of hierarchy to reload I have used all available settings in DTP(Full Update/Update Subtree/Insert Subtree) none of them work. It alwasy thorws same error message. Your help will solve my production issue.

Regards,

Vaishu

[Former Member]

Hi Vaishu

enabled Update Subtree

In the InfoPackage for load, please choose the 'Full Update' option instead of the 'Update Subtree' option. This should ensure completion of the hierarchy load without any errors.

Regards

Jhansi

[Former Member]

Hi Jhansi/Tibollo,

I have tried both options but didn't work. It still throws same error message mentioned above. I guess structure is not updating I mean after load 1.a.1.1 still pointing to old parent 1.a.1 rather than 1.a.2, which is causing this issue.

Thanks for quick response.

Regards,

Vaishu

[former_member186445]

Did you try deleting the hierarchy manually via RSD1? if you first do this and then reload from psa this should work fine.

M.