TM1 Forum

Is there a way in a rule to reference an element that has a single quote (apostrophe) in the name?

I think there is an escape character, but I can't think of it. The other alternative is to create an alias and reference the alias in the rule instead.

Martin

You could joining text strings and using Char(39), for example 'SomeText' | Char(39) | 's String'

Hi
Try putting another single quote in front of the single quote that is part of your element name.

Element Name: Blah'Blah

Rule: ['Blah''Blah']=N:1;

Cheers

Edit: Forgot the ending single quote, sorry.

... goes without saying but always a very bad idea to have any kind of reserved characters in any TM1 object or element names. Especially ones that interfere with writing rules or MDX.

True, Lotsaram.

See: http://users.skynet.be/fa436118/wim/tm1singlequote.htm