Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 08, 2010 at 01:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hey Patrick,

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