Skip to Content
0

Parent nodes position during hierarchy upload from infoobject BPC 10.1 NW

Sep 07, 2017 at 09:52 AM

71

avatar image
Former Member

Hi experts,

I am working with BPC 10.1 NW. These are the components:

I have several hierarchies in ACCOUNT dimension. I upload them toguether with a execution of /CPMB/IMPORT_IOBJ_HIER. The problem is that in the PARENTH2 the mother node (main node) appears at the bottom of the hierarchy view (dimension sheet in the webclient). I must press many times "View next 100 items" in order to replace manually the mother node from bottom to the top of that hierarchy view.

Each time PARENTH2 is uploaded again from the infoobject, the mother node position comes back to the bottom!

The question is: how can I manage to place automatically the mother node at the top directly? It is possible? I know the ORDER parameter in the transformation file, but I don't find detailed information about it.

I would appreciate some help.

Thanks.

Regards,

Manu

2017-09-07-1124.png (43.5 kB)
SAP Business Planning and Consolidation, version for SAP NetWeaver
hierarchy node | infoobject | import hierarchy | hierarchy view
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Vadim Kalinin Answered Sep 07, 2017 at 10:08 AM
0

Sorry, but why do you change this node manually? Can be done using transformation/conversion.

Please provide detailed info with screenshots.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Former Member
Oct 10, 2017 at 03:01 PM

Thank you for your answer, Vadim.

As you may observe in the following screenshots, the main node is at the top of the list, as it should be, in hierarchies one and three. PARENTH2 is where the problem explained before shows up.

  • PARENTH1:

  • PARENTH3:

  • PARENTH2:

I didn't find detailed information about the ORDER parameter application in the transformation file, so, as you suggested in your answer, I attach screenshots of both the transformation and conversion file:

  • TRANSFORMATION FILE

  • CONVERSION FILE:

In order to make it easier to analyze, I include some screenshots of the hierarchies in BW:

  • PARENTH1:

  • PARENTH2:

  • PARENTH3:

I would appreciate some help, thanks in advance.

Regards.

Manu.

2017-10-10-1327-001.png (21.8 kB)
2017-10-10-1328.png (21.6 kB)
2017-10-10-1329.png (20.0 kB)
2017-10-10-1322.png (17.6 kB)
2017-10-10-1323.png (13.9 kB)
2017-10-10-1323-001.png (22.0 kB)
2017-10-10-1324.png (12.6 kB)
2017-10-10-1647.png (51.7 kB)
2017-10-10-1653.png (43.8 kB)
2017-10-10-1655.png (51.2 kB)
0
Vadim Kalinin
Oct 10, 2017 at 03:23 PM

OK, may be now I managed to understand your issue!

To my mind you can do nothing with order parameter...

May be you can create dummy nodes in all hierarchies to assign members with empty hierarchy parent?

0
Comment