TM1 Forum

Hi all,

I am experiencing some unexpected behaviour when using the Pick Dimension option on a worksheet.

I have a dimension called 6.1_CostCentre and the server name is 09 Financial Planning

So when I use Pick Dimension I expect to see the following on the worksheet:

09 Financial Planning:6.1_CostCentre

But what I actually get is 09 Financial Planning:6

If I try to use the Pick Element option it opens a subset editor but returns no elements because it is trying to pick elements from 09 Financial Planning:6, which doesn't exist.

If I manually type the correct dimension name on the worksheet and use any functions, such as Elpar, the functions returns the correct value.

cheers, Mark

It appears to be just one more idiosynchracy that shows up when you begin TM1 object names with numbers. I try to avoid it wherever possible because of strange things like this.

Cheers Tom,

Yes just tested with a name not starting with a number and looks ok.

Back to the drawing board with the naming convention!

I've seen something like this before - it might not be the number, but the full stop that's the issue. FWIW...

Thanks Paul, though I have just changed the number naming system for an alpha one!

I guess the trick is to avoid symbols and numbers, this was a naming system I inherited but will take the advice from here and rip it all up going forward!

cheers, Mark

It is almost unavoidable having some element names being all numeric text, so I don't worry about it too much. However, I never start cube or dimension names with a number, always text. Instead of 1Q Data I would have Q1 Data and so forth.