Pick Dimension Worksheet

Post Reply
Mark RMBC
Regular Participant
Posts: 164
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 » Thu Jan 25, 2018 1:05 pm

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: 2503
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 » Thu Jan 25, 2018 3:06 pm

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
Regular Participant
Posts: 164
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 » Thu Jan 25, 2018 3:38 pm

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: 251
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Pick Dimension Worksheet

Post by Paul Segal » Wed Jan 31, 2018 11:29 am

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
Regular Participant
Posts: 164
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 » Thu Feb 01, 2018 8:46 am

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: 2503
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 » Thu Feb 01, 2018 12:15 pm

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