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
Pick Dimension Worksheet
-
- 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
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.
-
- 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
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!
Yes just tested with a name not starting with a number and looks ok.
Back to the drawing board with the naming convention!
-
- 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
I've seen something like this before - it might not be the number, but the full stop that's the issue. FWIW...
Paul
-
- 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
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
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
-
- 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
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.