Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import Package

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.

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question