Skip to Content
0
Sep 23, 2011 at 11:20 AM

conversion file formula not working

24 Views

I have the below scenario.. (BPC NW 7.5 Version)

in flat file for cost center dimension, i have values as

1. 65-adm-01

2. 65-fa-01

where as bpc costcenter dimension wont accept the symbol "-" (hyphen) . i want to conver the above into ("-_) (underscore)

1. 65_adm_01

2. 65_fa_01

i tried giving the below in converison file and also in the transformation file i have written CONVERSION_INTERNAL = YES

external | internal | formula

-


|--


|--


  • | * | js: %external%.replace("-", "_");

it is not working..am i missing somethgin.... Pls advice.. Thank you..