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.
Nicola
naming convention issue, dimension with spaces
- Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: naming convention issue, dimension with spaces
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.
HTH,
Martin
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.
HTH,
Martin
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
Jodi Ryan Family Lawyer