TM1 websheet - SUBNM work only in Administrator User
-
- Posts: 51
- Joined: Wed Oct 09, 2013 2:29 pm
- OLAP Product: Cognos
- Version: 10.1
- Excel Version: 2010
TM1 websheet - SUBNM work only in Administrator User
Hi
I have big problem. I have websheet's there function SUBNM("CXMD:dimName";"";"") works only in administrator Login. In other user there's not triangle to start window where i can choose valuse from list.
Please Help
I have big problem. I have websheet's there function SUBNM("CXMD:dimName";"";"") works only in administrator Login. In other user there's not triangle to start window where i can choose valuse from list.
Please Help
-
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
I'm not sure what a triangle has to do with it, nor the semi-colons in the formula. However if a SubNm works on an Admin login but not on other logins, wouldn't this normally suggest that you have security on the dimension and that the other group(s) do not have the necessary security access?Motyl wrote: I have big problem. I have websheet's there function SUBNM("CXMD:dimName";"";"") works only in administrator Login. In other user there's not triangle to start window where i can choose valuse from list.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3230
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
Not everyone on earth uses a comma as the separator for arguments in a formula.Alan Kirk wrote:nor the semi-colons in the formula
Belgians generally use ; as a separator.
Yes, it's annoying

Best regards,
Wim Gielis
IBM Champion 2024-2025
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
Wim Gielis
IBM Champion 2024-2025
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
-
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
Such eccentricity is allowed in Belgium.Wim Gielis wrote:Not everyone on earth uses a comma as the separator for arguments in a formula.Alan Kirk wrote:nor the semi-colons in the formula
Belgians generally use ; as a separator.
Yes, it's annoying
The chocolate more than makes up for it.

"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
Don't forget the fine fruit beers and the mussels!!
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
Mussels from Brussels, eh? I thought it was muscles from Brussels...jim wood wrote:Don't forget the fine fruit beers and the mussels!!
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User

Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 3230
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
You're all welcome to taste the mussels and other fine stuff in Belgium! *Beer* 
We can enjoy these nice things in life while also chatting about TM1

We can enjoy these nice things in life while also chatting about TM1

Best regards,
Wim Gielis
IBM Champion 2024-2025
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
Wim Gielis
IBM Champion 2024-2025
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
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
Where's the like button on this site when you need it???Wim Gielis wrote:You're all welcome to taste the mussels and other fine stuff in Belgium! *Beer*
We can enjoy these nice things in life while also chatting about TM1
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 1828
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
Does this suggest that TM1 isn't one of the nice things in life?Wim Gielis wrote:You're all welcome to taste the mussels and other fine stuff in Belgium! *Beer*
We can enjoy these nice things in life while also chatting about TM1

Declan Rodger
-
- MVP
- Posts: 3230
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 websheet - SUBNM work only in Administrator User
I'm sorry Declan, I take back the previous post.
Only 3 characters in total but such a nice thing
No, I didn't mean IBM, but TM1.
Only 3 characters in total but such a nice thing

Best regards,
Wim Gielis
IBM Champion 2024-2025
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
Wim Gielis
IBM Champion 2024-2025
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