BPC Conversion file not applying Formula

[Former Member]

Dear Experts,

We are currently running:

Client : Add-in SAP EPM 10.0 SP 15 patch 2 .Net3.5 - Build 8586

Server : BPC 10 NW

We are importing rates data into Rates model of BPC from a BW DSO. The data imports successfully , but the amount is not multiplied or divided when the formula column in the conversion file is used.

Please suggest in case of any solution or update required ??

Transformation File:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=0

ROUNDAMOUNT=

CONVERTAMOUNTWDIM =

*MAPPING

C_CATEGORY= *NEWCOL(Actual)

INPUTCURRENCY= ZCUR_TYPE

TIME = ZTIME

R_ACCOUNT= ZRTYPE

R_ENTITY = *NEWCOL(Global)

SIGNEDDATA=ZKEYFIGR

*CONVERSION

INPUTCURRENCY=INPUTCURRENCY.xls!INPUTCURRENCY

Conversion File :

External      Internal      Formula

*                   *             Value*100

Thanks in advance

Makarand

[gajendra_moond · Accepted solution]

Hi Makarand

It should be

AMOUNT=INPUTCURRENCY.xls!INPUTCURRENCY

[gajendra_moond · Accepted solution]

Hi Makarand

Did that not solve your problem?

[Former Member · Accepted solution]

Thanks Gajendra it did work..

Along with your suggestion I applied SAP note 0001932015 Conversion file formula program error. 

Thanks,

Makarand

[gajendra_moond · Accepted solution]

Great.

If you could mark the thread as answered, that would be helpful for others as well. Thanks.