Import Package

[Former Member]

All,

I would like to load text file into BPC. But I would like multiply the value by 2. Do I do this in the conversion file? I have a conversion file for Time and Entity. In the entity conversion file, I specified under the formula column, VALUE * 2. But it does not do it. How do I achieve this? The account I am loading to is a EXPense account.

Thanks in advance.

[PatrickFavre · Accepted solution]

Hi,

You should use CONVERTAMOUNTWDIM=<your dim> into OPTION section of the Transformation file.

Then, if you have something in the MAPPING section, ensure that your use "AMOUNT=....." instead of "SIGNEDDATA=.....".

Please also make sure that your flat file is having a header called AMOUNT, when not using MAPPING section.

Then, in the CONVERSION section, add two lines like these for example:

Account = Account.xls

Amount = Account.xls (meaning that Formula column in account.xls conversion file is filled in with VALUE * 2

In any case, this simple example is working fine in ApShell.

I hope this will help you.

Best Regards,

Patrick

[Former Member · Accepted solution]

Hey Patrick,

Its working awesome!! What I missed was the CONVERTAMOUNTWDIM thing in the options. Thanks.