TM1 Forum

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 Segal wrote:Is this old news and I've just not come across it before?

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.

I certainly feel for anyone if it is a new thing and they'd have to go through updating entire naming conventions.

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.

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.

IMO that's the best practice approach. I've seen usage of $, % and & cause problems on TM1 Web so I would avoid those too.

Just saw this article which may be useful in terms of reserved characters and do's and dont's.