BPC 10.1 NW Hierarchy Load DMP Error

[pankajkumar_gilda79]

Hi Gurus,

I am facing with an error during the import of hierarchy XYZ_ORG from info object ZXYZ_ORG. I managed to import master data successfully with the package /CPMB/IMPORT_IOBJ_MASTER.

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

The info Object in BW has the following

My Transformation File

Conversion File

SET Selection Screen

Members maintained in the XYZ_ORG

I have searched many blogs but to no success in resolving it. Please help me to resolve the issue.

Regards

KMG

[pankajkumar_gilda79]

Hi Vadim,

Corrected as per your suggestion. But still facing the issue.

I have run the text load package with Hierarchy text to be loaded.

Result of Text Load Package

It is missing around 100 Text nodes here.

Then I run the Hierarchy Package:

The missing text is the error. Any suggestions.

Regards

KMG

[former_member186338]

Sorry, but I have already told you that to remove leading zeros you don't need to use conversion file!!!

When you run data or hierarchy import package you have an option - internal or external!

Use external

[pankajkumar_gilda79]

Hi Vadim,

The text load has been resolved but I am issue with the Hierarchy load.

For Text Load I manually maintained the members in the conversion file.

For Hierarchy the following is the conversion file I have maintained.

After load the following is the error:

Regards

KMG

[pankajkumar_gilda79]

Hi Vadim,

Thanks. Things are working. But as I looked into the text load of the dimension, I wanted to remove preceding zeros in conversion file. The following is the file

Result:

BW Infoobject:

Can you please help me to load this. Is something in missing conversion file.

Thanks in advance.

[pankajkumar_gilda79]

Hi Vadim

As suggested maintained the sheet name. Now the result is different.

Result

[former_member186338]

1. When importing - use External to remove zeros!

2. Check - do you have node members in BPC (when you load master data) = like 1000C-1000...

[former_member186338]

In the conversion section of transformation file add sheet name for HIER_NAME line

[pankajkumar_gilda79]

Hi Vadim,

I have maintained PARENTH1. Here is the screenshot of it.

Regards

KMG

[former_member186338]

Have you created hierarchy PARENTH1 in BPC dimension? Please show screenshot of dimension structure.