on ‎2020 Nov 16 4:32 PM
Since BPC 10.1 Standard, I find myself trying to load the members and hierarchies for the infoobject named "0MAT_SALES". However, when loading the package of: - Texts and attributes load successfully - When loading hierarchies it says successful, but only assigns a total grouper for all members. When I go to review the infoobject in BW "0MAT_SALES" I have seen that it has fields with different names as you can see in the following image:

1. Corresponds to the 0HIER_NODE field, it is the only one that appears.
2. Corresponds to levels starting with 0PRODH *
3. Corresponds to the members of the infoobject
The critical point is that at point 2. which corresponds to the levels that start with 0PRODH * they do not load into the dimension as members. My question is, can it be possible that they also load and be able to see them as a hierarchy in my dimension?
I attach my text and attributes transformation file

I attach my conversion files

I attach my hierarchies transformation file

I attach my hierarchies conversion files

Dimension PRODUCT
I attach an image of the Product dimension, where it is seen that these levels did not load and the PARENTH1, I had to temporarily load it manually to a single Node, but it is not the objective.

Could you help me and guide me if I can load the levels and how can I do it?
thanks for your help
Request clarification before answering.
I think that then there is no solution for this. To load this type of hierarchies from Bw that have a field name other than (0HIER_NODE). Since they are arriving with a field called "0PRODH1 to 0PRODH9". I'm very sorry for the Bloq Mayus, it was a mistake on my laptop.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can anyone help or guide me in this situation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 16 | |
| 8 | |
| 7 | |
| 6 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.