Naming Conventions Elements

Post Reply
MarenC
Posts: 82
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Naming Conventions Elements

Post by MarenC » Sat May 23, 2020 9:49 am

Hi,

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

Maren

User avatar
Alan Kirk
Site Admin
Posts: 6123
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Naming Conventions Elements

Post by Alan Kirk » Sat May 23, 2020 9:58 am

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Naming Conventions Elements

Post by EvgenyT » Mon May 25, 2020 4:01 am

I try to avoid in case it may conflict with delimiters

Post Reply