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.
Patrick Favre replied
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.