on 07-03-2017 5:53 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.