COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: cognos05 on 16 Apr 2017 11:29:46 PM

Title: Cognos transformer Special Character
Post by: cognos05 on 16 Apr 2017 11:29:46 PM
Hi,

I have a  customer dimension in which we have customer name and Customer number as the lowest level member and its unique item .

This lowest level has special characters in its text and cognos transformer throws error while building the cube .

How to handle the special character in cognos transformer and do i need to set the data type as text for this issue or any other type .

The Member text/value is Daonsa dadadades,S.A. de C.V - 678P - HJ02

Any help on how to handle this is appreciated .Is the error causing because I have "," comma in my element text

The error was special character text .

Thanks,
Nithya