Dimension subset editor in TM1 Perspectives

Post Reply
lax9
Posts: 12
Joined: Thu Apr 12, 2018 9:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Dimension subset editor in TM1 Perspectives

Post by lax9 »

Hi All,

In TM1 Perspective Report I tried to open up the dimension subset editor, but not able to. (no error msg though )

what may be the reason that i am not able to go into the subset editor?

Please share your thoughts if you have idea on this. Thank you!
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Dimension subset editor in TM1 Perspectives

Post by Wim Gielis »

It could be that the Subset Editor is shown (or TM1 tries to show) on a second monitor.
Do you have such a setup of a dual monitor ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
lax9
Posts: 12
Joined: Thu Apr 12, 2018 9:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Dimension subset editor in TM1 Perspectives

Post by lax9 »

no , it's not related to the monitor.

I believe the issue is within the excel sheet subnm formula (TM1 perspectives).
Able to open the same report and nable to access dimension subset editor from another instance on the same server.
tm123
Posts: 132
Joined: Thu Oct 23, 2014 10:15 pm
OLAP Product: tm1, cognos bi
Version: 10.2
Excel Version: 2010

Re: Dimension subset editor in TM1 Perspectives

Post by tm123 »

In my opinion, SUBNM formulas in TM1 Perspectives never work properly. I usually get Visual Basic Error when I double click on a SUBNM cell from Perspectives so I do all my testing from TM1Web
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Dimension subset editor in TM1 Perspectives

Post by Wim Gielis »

tm123 wrote: Thu Jun 07, 2018 7:12 pm In my opinion, SUBNM formulas in TM1 Perspectives never work properly. I usually get Visual Basic Error when I double click on a SUBNM cell from Perspectives so I do all my testing from TM1Web
I wouldn't say "never", but you are right, we all have double-clicked SUBNM's just to end up with no ribbon icon labels. Or with the cell showing the SUBNM formula as text rather than the result. Or with Excel crashing. Or ......... just add to the list yourself.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Dimension subset editor in TM1 Perspectives

Post by Steve Rowe »

The other reason that the subnm double click often fails is that people often try and reference another cell to get the server name, this will stop the double click from working.

=Subnm("Server:Dimension",....

works

=Subnm( A1 & ":Dimension",....

will not work
Technical Director
www.infocat.co.uk
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Dimension subset editor in TM1 Perspectives

Post by Wim Gielis »

Steve Rowe wrote: Fri Jun 08, 2018 11:24 am The other reason that the subnm double click often fails is that people often try and reference another cell to get the server name, this will stop the double click from working.

=Subnm("Server:Dimension",....

works

=Subnm( A1 & ":Dimension",....

will not work
Just tested it and it works fine. PAL 2.0.4, Excel 2016. And I should say, it would be a shame if this would not work. How else are we supposed to keep the websheets maintainable ? I.e. TM1 servername in a named range or cell.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Dimension subset editor in TM1 Perspectives

Post by Steve Rowe »

AS Wim points out this behaviour does vary by version....
Technical Director
www.infocat.co.uk
tm123
Posts: 132
Joined: Thu Oct 23, 2014 10:15 pm
OLAP Product: tm1, cognos bi
Version: 10.2
Excel Version: 2010

Re: Dimension subset editor in TM1 Perspectives

Post by tm123 »

Also another reason is Protecting the Sheet.

If you procect the sheet, you have to make sure that all the cells with SUBNM formulas are unlocked, otherwise you get a VBA error when you double click and after that point, you have to re-launch Perspectives.

But in TM1Web, the SUBNM will work fine even if you don't unlock the SUBNM cells
lax9
Posts: 12
Joined: Thu Apr 12, 2018 9:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Dimension subset editor in TM1 Perspectives

Post by lax9 »

Thank you all for the replies.

Based on your thoughts and recommendation I did check the subNM formulaes and noticed that they are pointing to another server , I set it to the correct server. Thank you All..
Post Reply