apostrophe problem in TM1

[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

[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

[sara]

thanks a looot for the tip it worked