Allow commas in the name while transferring to BPC

123 Views

Hi,

I am trying to load data to a dimension in BPC, named CUSTOMER. The dimension has following properties:

ASM, SEGMENT, SHIP_TO_STATE,SHIP_TO_NAME and SHIP_TO_STATE apart from ID EvDescription and Scaling.

I have problem populating the SHIP_TO_NAME property. I am mapping that with 0NAME attribute of 0CUSTOMER from the BW side in my transformation file. And I have "," (Comma) in my name and I want to retain that in the BPC. How can I retain this comma while transferring the records?

I thought of possible option as changing the DELIMITER option from default "," to something else, but then it would be a problem to define the columns.

Also, if anyone knows how to change the delimiter of the output of transformation, if I dont want "," as my default delimiter?

Please help me on this one. Any help is appreciated.

Thanks,

Abhishek