TM1 Forum

Hi,

I try to avoid special characters in principal dimension element names but should I extend this to aliases?

Maren

MarenC wrote: ↑Sat May 23, 2020 9:49 am I try to avoid special characters in principal dimension element names but should I extend this to aliases?

I prefer to, but I've become more relaxed about it in recent years. My theory is that if you're going to be doing automation operations (which is the main reason for avoiding the special characters, since they can inject "unexpected surprises" into some scripting languages), you'll generally do it on the principal name.

However even now I still try to avoid double quotes and apostrophes because those can be a royal pain in the backside with some string operations, including SQL like queries.

I try to avoid in case it may conflict with delimiters