Allow commas in the name while transferring to BPC
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.