Error BPC 10.1 "Hierarchy ***** does not exist in BPC"

[lean_5]

Hi experts,

These are my BPC version and SP level and I have EPM 28.3 in Office 2016:

SAP_BW: 740 SP15

CPMBPC: 810 SP10

I am facing with an error during the import of hierarchy ZHIER_CC from infoobject 0WBS_ELEMT. I managed to import master data succesfuly with the first package /CPMB/IMPORT_IOBJ_MASTER.

I have read a lot of threads about my error, but it was not helpful for me.

When I am uploading second package /CPMB/IMPORT_IOBJ_HIER, it fails with the next log:

My BPC dimension is PROYECTO. It has three hierarchies into its structure (PARENTH1, PARENTH2, PARENTH3)

This is my hierarchy in BW side. This 0WBS_ELEMT has 4 hierarchies,

I am using these transformation file and conversion file:

*MAPPING NODENAME=NODENAME HIER_NAME=HIER_NAME PARENT=PARENT ORDER=ORDER


*CONVERSION NODENAME=PROJECT_CONV_HIER1.xls!NODENAME HIER_NAME=PROJECT_CONV_HIER1.xls!HIER_NAME PARENT=PROJECT_CONV_HIER1.xls!PARENT

In NODENAME sheet of conversion file, I have:

* js:%external%.toString().replace(/ /m,"_").replace(/ /m,"_").replace(/ /m,"_").replace(/\u0027+/g,".").replace(/\u0028+/g,"-").replace(/\u0029+/g,"-").replace(/\u002C+/g,".").replace(/\u002F+/g,"-").replace(/\u002B+/g,"&").replace(/\u003A+/g,"-").replace(/\u0022+/g,"."). replace(/\u003B+/g,".")

When I validate the transformation file shown above with the hierarchy infoobject 0WBS_ELEMT, I get a correct result.

When I run the package /CPMB/IMPORT_IOBJ_HIER, this is my set selection and the hierarchies does not have versions.:

Here you can see P_1656-000 is a node and not a hierarchy

I have tried differents ways to run the package of hierarchy. With overwrite, update, internal, external...all combinations. I get the same error always.

I would appreciate any help of you.

Kind regards,

Leandro

[lean_5]

Hi Vadim,

Thank you for your quick response. Sorry for my log, but I couldn't get an english log. The log translation is as follows:

Task name HIERARCHY DATA SOURCE:

Info: Hierarchy node includes text node or external characteristics

Record count: 1651

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 1651

Skip count: 0

Accept count: 1651

Task name HIERARCHY DATA TARGET:

Error enconuntered in the sysem

Hierarchy P_1656-000 does not exist in BPC

I have changed the nodename tab in conversion file, but I got the same error:

Kind regards,

Leandro

[former_member186338]

Sorry but I am unable to check on your system how you get this missing member...

[former_member186338]

Sorry, but if you provide not English log you have to translate each line!

Node name conversion file is strange: if you have * in the first line then only this first line will be processed (only single line of conversion file is processed if condition is matched).