Pick Dimension Worksheet

Post Reply
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Pick Dimension Worksheet

Post by Mark RMBC »

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
tomok
MVP
Posts: 2831
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: Pick Dimension Worksheet

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Pick Dimension Worksheet

Post by Mark RMBC »

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!
Paul Segal
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

Re: Pick Dimension Worksheet

Post by Paul Segal »

I've seen something like this before - it might not be the number, but the full stop that's the issue. FWIW... :D
Paul
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Pick Dimension Worksheet

Post by Mark RMBC »

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
tomok
MVP
Posts: 2831
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: Pick Dimension Worksheet

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply