Page 1 of 1

apostrophe problem in TM1

Posted: Fri May 06, 2011 2:47 pm
by sara
Hello everybody,

I'm facing a technical problem with COGNOS TM1, i have a dimension that includes an element with apostrophe (i'm using TM1 in french), the problem is when i want to use this element in a rule TM1 doesn't recognise it because the elements are used in the rules with quotes, and TM1 confuses the quote with the apostrophe. here is my rule: ['Chiffre d'affaires (HT)']=['Quantité vendue']*['Prix unitaire'];

I hope i was clear, plz cloud anyone help me any suggestions are welcome.

excuse the spelling mistakes :)

Re: apostrophe problem in TM1

Posted: Fri May 06, 2011 3:58 pm
by Mike Cowie
Hello:

Try escaping the 1 single quote in the element name with 2 single quotes:

Code: Select all

['Chiffre d''affaires (HT)']=['Quantité vendue']*['Prix unitaire'];
This is TM1's escape sequence (2 single quotes together = 1 single quote in a name) so that you can refer to a single quote in the element name and avoid this problem (also works in Turbo Integrator, too).

Hope that helps!

Regards,
Mike

Re: apostrophe problem in TM1

Posted: Sat May 07, 2011 11:15 pm
by sara
thanks a looot for the tip it worked