Formula in conversion sheet doesn't work

[Former Member]

Hi All,

Formula in conversion sheet doesn't work. BPC 10.0 CPMBPC801 SP 9. Below is the transformation file. Two fields are of importance -

1. 0COPASLQTY (BW Key Figure) mapped to signeddata

2. 0COPASLQTU (BW Unit) mapped to account. This could be KG or TO (tonnes).

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT= -1

ROUNDAMOUNT=

*MAPPING

Category=*NEWCOL(Actual)

RptCurrency=*NEWCOL(LC)

TIME=0FISCPER(1:4) + *STR(.) + 0FISCPER(6:7)

Product=0MATERIAL

COST_CENTER=0PLANT

Customer=*NEWCOL(Dummy_Customer)

PROFIT_CENTER=0PLANT

Account=0COPASLQTU

Segment=0PLANT

SIGNEDDATA=0COPASLQTY

*CONVERSION

PROFIT_CENTER=Planttoprofitcenter.xls

Segment=PlanttoSegment.xls

COST_CENTER=PlanttoCC.xls

Account=Account_KG_TO.xls

Below is the conversion file -

External               Internal               Formula

TO                    Vol_in                    Value*1000

KG                    Vol_in                   

The data gets loaded to Vol_in from both TO and KG but as is. The conversion from tonnes to KG is not happening. Any help is much appreciated.

Regards,

Ashish

[former_member186338 · Accepted solution]

Please read about CONVERTAMOUNTWDIM

Here: Data Transformation Maintenance - SAP BusinessObjects Planning and Consolidation - SAP Library

Vadim

[Former Member · Accepted solution]

Hi Vadim,

I added CONVERTAMOUNTWDIM=Account

It still doesn't work.

P.S. - I was under impression that we don't require this keyword for account dimension. Any more suggestions please?

Regards,

Ashish

[former_member186338 · Accepted solution]

"You must specify a dimension conversion sheet using the Amount in *Conversion option."

[former_member186338 · Accepted solution]

Like here:

[Former Member · Accepted solution]

Can you please elaborate? Do I need two conversions, one for account one for amount. Please if you can detail that out, it will help.

[Former Member · Accepted solution]

Thanks Vadim. You are helpful, to the point, as always!

Regards,

Ashish