Full stop in cube name breaks perspectives?
-
- Community Contributor
- Posts: 306
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Full stop in cube name breaks perspectives?
I've just come across an issue in Perspectives where Pick and Edit Formula from the TM1 menu break if you include a . in a cube name. So, SERVER: CUBE.DESCRIPTION will truncate to SERVER:CUBE, which is obviously not ideal. Running 10.2.2 FP2 on Excel 2010 with up to date Perspectives. Is this old news and I've just not come across it before?
Paul
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Full stop in cube name breaks perspectives?
It might be as I've always used an underscore as a result of encountering issues with full stops... but then again I can't remember what the issues I encountered were and that doesn't really ring a bell - I think the issues I found may have been more server file side e.g. when I tried to do certain things "outside" TM1 with "My.Cube.cub" etc.Paul Segal wrote:Is this old news and I've just not come across it before?
I certainly feel for anyone if it is a new thing and they'd have to go through updating entire naming conventions.
Declan Rodger
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Full stop in cube name breaks perspectives?
I never use "." or "," in any TM1 object names. I don't use "." because it is a separator for web addresses and don't use "," because it is the most common delimiter for text files. Guess I've been just been lucky. I only use letters, numerals, and underscore.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Full stop in cube name breaks perspectives?
IMO that's the best practice approach. I've seen usage of $, % and & cause problems on TM1 Web so I would avoid those too.tomok wrote:I never use "." or "," in any TM1 object names. I don't use "." because it is a separator for web addresses and don't use "," because it is the most common delimiter for text files. Guess I've been just been lucky. I only use letters, numerals, and underscore.
Robin Mackenzie
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Full stop in cube name breaks perspectives?
Just saw this article which may be useful in terms of reserved characters and do's and dont's.