Data manager Conversion file formula multiply by 1000 not working

[former_member85978]

Hi,

We are currently running:

Client : Add-in SAP EPM 10.9 SP 15 patch 1 .Net4 - Build 8536

Server : BPC 10 NW EP1 SP4

We are importing data into BPC from a flat csv file using the /CMPB/IMPORT package. The data imports successfully , but the amount is not multiplied by 1000 when including Value*1000 in the formula column in the conversion file. 

Please assist , with any suggestions to get the data in the csv file to be imported into BPC multiplied by 1000.

Thanks in advance

Gavin

Transformation file :

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=NO

MAXREJECTCOUNT=

ROUNDAMOUNT=

CONVERTAMOUNTWDIM = ACCOUNT

*MAPPING

ACCOUNT=ACCOUNT

*CONVERSION

AMOUNT=ACCOUNT_MULTIPLY_TEST.XLS

ACCOUNT=ACCOUNT_MULTIPLY_TEST.XLS

Conversion file:

EXTERNAL	INTERNAL	FORMULA
312700	100000	Value*1000
*	*	Value*1000

CSV file :

ACCOUNT

SUPPACC

PCENTRE

TIME

INTERCO

ENTITY

AUDITID

CURRENCY

FLOW

CATEGORY

LOB

CCENTRE

SIGNEDDATA

CONSOSCOPE

312700

S_NONE

PC_1

2014.SEP

I_NONE

LE_1

INPUT

LC

F99

BM

Lob_1

CC_NONE

-2700

G_NONE

100010

S_NONE

PC_1

2014.SEP

I_NONE

LE_1

INPUT

LC

F99

BM

Lob_1

CC_NONE

13000

G_NONE

100032

S_NONE

PC_1

2014.SEP

I_NONE

LE_1

INPUT

LC

F99

BM

Lob_1

CC_NONE

-1600

G_NONE

100011

S_NONE

PC_1

2014.SEP

I_NONE

LE_1

INPUT

LC

F99

BM

Lob_1

CC_NONE

-1450

G_NONE

100012

S_NONE

PC_1

2014.SEP

I_NONE

LE_1

INPUT

LC

F99

BM

Lob_1

CC_NONE

-1600

G_NONE

[former_member85978 · Accepted solution]

Hi,

Applied the following SAP Note and it resolved the problem.

SAP note 0001932015 Conversion file formula program error.

Formula in conversion file doesn't work

Regards

Gavin

[brahmareddy_kolli]

Hi,

1.transformation option Convert_internal = YES, *IF can be used in the External column or the transformation option Convert_internal = NO, *IF can be used in the Internal column.

2.CONVERTAMOUNTWDIM=dimension name

3.diffrent conversation file for multiplication's

With Regards

Brahmareddy kolli

[former_member186498]

Hi Gavin,

see please http://service.sap.com/sap/support/notes/1804424 maybe it helps.

Regards

     Roberto

[former_member85978]

Hi Roberto,

Thanks for the suggestion , I read note http://service.sap.com/sap/support/notes/1804424  and it does not assist with the problem I'm currently having.

My problem is that I would like the data I have in a flat file to be multiplied by 1000 by using the Transformation and conversion file formula in BPC, however it does not multiply the original.

Thanks

Gavin

[akos_beres]

Gavin,

try removing Account after Convertamountwdim and simply leave it blank. It worked for me in BPC 10 MS not sure if it will work in NW.

Akos

[former_member85978]

Hi Akos,

thanks for the suggestion , I removed ACCOUNT after CONVERTAMOUNTDIM , but it still does not multiply the amount by 1000.

CONVERTAMOUNTWDIM=

*MAPPING

ACCOUNT=ACCOUNT

*CONVERSION

ACCOUNT=ACCOUNT_MULTIPLY_TEST.XLS

AMOUNT=ACCOUNT_MULTIPLY_TEST.XLS

[Former Member]

So what do you need to do:

In the conversion workbook, add a sheet called amount. Here you maintain the following syntax:

EXTERNAL	INTERNAL	FORMULA
*	*	VALUE*1000

You can add it to the existing conversion file, this will then have 2 worksheets instead of one.

I only got it working, if I created a specific conversion sheet for the Value*1000.

Then in the transformation file, you reference the specific worksheets.

*CONVERSION

ACCOUNT=ACCOUNT_MULTIPLY_TEST.XLS!CONVERSION

AMOUNT=ACCOUNT_MULTIPLY_TEST.XLS!AMOUNT I am assuming here that the first worksheet you have is called Conversion, but if this name is different you can use that name.

[akos_beres]

Gavin,

you are correct my transformation file also references amount in the conversion section. The devil is in the details!

Akos

[former_member85978]

Hi Tim,

I created a sheet for AMOUNT in ACCOUNT_MULTIPLY_TEST.XLS, but it still does not multiply the amount by 1000.

Thanks

Gavin