Error when loading data from InfoCube into BPC- How to analyse?

[Former Member]

Hi, all, I want to load data from an InfoCube into BPC 10.1 NW. I always get an error. I have checked my conversion files. The problem occurs since I want to map GL accounts to my accounts in BPC.

Could anybody please give me some advice on how to analyse the issue?

Thanks in advance and best regards

Gerd

[Shrikant_Jadhav · Accepted solution]

Hi Gerd,

Kindly share the transformation, conversion file and detail error log.

Also share the sample data.

Shrikant

[Former Member · Accepted solution]

Hi, Shrikant,

thanks for your answer.

The transformation file looks like this:

The conversion file for the accounts looks like this:

The conversion file for the flows looks like this:

The conversion file for the intercompanies looks like this:

When I try to load the data from the InfoCube into BPC I get the following error:

It seems that the data manager has problems solely with the account in the account dimension. In my opinion the the transformation file does not find the conversion file for the account although the name of the conversion file for the accounts is the same as in the transformation file.

This is a screenshot of the sample data:

Could you please help me further why the upload from the InfoCube into BPC does not work?

Thanks in advance and best regards

Gerd

[Shrikant_Jadhav · Accepted solution]

Hi Gerd,

Validate transformation file. Check whether you are getting same error or not.

Check one more time name of conversion file maintained in transformation file and file name.

Check the format of "EXTERNAL" column in Account conversion file - TEXT.

Shrikant

[Former Member · Accepted solution]

Thanks you, You have helped me a lot. It was the setting for text in Excel.

Best regards

Gerd