Conversion File formula Value*-1 BPC 7.5 NW

[Vishwanathg7]

Dear Freinds,

My requirement is to change the sign of data while loading the data into BPC using BPC tranformation and conversion file.

I tryied with Convertion formuls

EXTERNAL INTERNAL FORMULA

0080100006 IC_80100006 VALUE*-100

my transformation file

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=NO

CREDITPOSITIVE=NO

MAXREJECTCOUNT=-1

ROUNDAMOUNT=

SELECTION=0GL_ACCOUNT,0080100006;

other things are normally working , Kindly sugesst were I gone wrong .

Thanks !

[Former Member]

Hi vishwanathg7,

If you Want to change the sign of the data all you have to do is put the credito positive in yes, like this

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=NO

CREDITPOSITIVE=YES

MAXREJECTCOUNT=-1

ROUNDAMOUNT=

SELECTION=0GL_ACCOUNT,0080100006;

HOPE THIS HELPS,

Edited by: Guillermo Ferro on Apr 4, 2011 3:51 PM

[Vishwanathg7]

Dear Guillermo Ferro,

Thanks ! for your reply.

Creditpositive = YES , will change the LEQ , INC account type only And not for EXP,AST account types. My requirement is to change the sign for all account types . I am able to do so through script logic but it put additional step for enduser. Which i belive can be avoided by using Conversion files Formulas.

I want to know about the conversion file Formula options ( value*-1) mentioned in sap help

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/bpc_nw_index.htm

Thanks ! in advance.

[former_member190501]

Hi,

Your conversion file is correct. To convert sign based on the accounts maintained in conversion file maintain transformation as follows:

*OPTIONS

CREDITPOSITIVE=NO

*MAPPING

..

...

*CONVERSION

AMOUNT = <Account Conversion file name>.XLS

hope it works...

regards,

Raju

[Vishwanathg7]

Dear,

I tried the same its not working.

Is it worked for you ?

[former_member190501]

Hi,

Yes! Its working for us.

Have you given both as follows:

*CONVERSION

<Account dimension>= <Account Conversion file name>.XLS

AMOUNT = <Account Conversion file name>.XLS

Edited by: VaraPrasadraju Potturi on Apr 5, 2011 10:46 AM