Skip to Content
0
Former Member
Oct 28, 2013 at 12:37 PM

Data manager Conversion file formula multiply by 1000 not working

712 Views

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