naming convention issue, dimension with spaces

Post Reply
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

naming convention issue, dimension with spaces

Post by nicola531 » Mon Feb 08, 2010 10:42 pm

Hello everybody,

I've got a naming convention issue with dimensions.
Have someone experienced a trouble in TI process function when using a dimension name with spaces like for instance "Dimension 1"

In particualar in the function CellPutN or CellPutS.

Thanks in Advance for you reply.

User avatar
Martin Ryan
Site Admin
Posts: 1958
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand

Re: naming convention issue, dimension with spaces

Post by Martin Ryan » Mon Feb 08, 2010 10:47 pm

Hi Nicola,

Spaces are fine in dimension names, and their use or non-use is a matter of personal preference.

I think the issue you're referring to is that if you use a cube as a source to a TI process where the cube has dimensions with names that have spaces, then the variable names in the Variables tab do not relate to the dimension name (but they use the dimension name if there is no space), this is because variable names cannot have spaces in them. This is not really a big deal, it just means you have to change the variable name from 'Dimension 1' to be 'dim1' or similar.

In the TI code itself if you explicitly mention the dimension you'll having to reference it in single quotes ('dimension 1') but this is the case regardless of whether there is a space or not otherwise TI will think you are referring to a variable, not an actual string.

Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer

Post Reply