TM1 websheet - SUBNM work only in Administrator User

Post Reply
Motyl
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

Post by Motyl »

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
Alan Kirk
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

Post by Alan Kirk »

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.
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?
"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.
Wim Gielis
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

Post by Wim Gielis »

Alan Kirk wrote:nor the semi-colons in the formula
Not everyone on earth uses a comma as the separator for arguments in a 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
Alan Kirk
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

Post by Alan Kirk »

Wim Gielis wrote:
Alan Kirk wrote:nor the semi-colons in the formula
Not everyone on earth uses a comma as the separator for arguments in a formula.
Belgians generally use ; as a separator.
Yes, it's annoying ;-)
Such eccentricity is allowed in Belgium.

The chocolate more than makes up for it. :ugeek:
"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.
User avatar
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

Post by jim wood »

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
User avatar
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

Post by Michel Zijlema »

jim wood wrote:Don't forget the fine fruit beers and the mussels!!
Mussels from Brussels, eh? I thought it was muscles from Brussels...
User avatar
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

Post by jim wood »

:D erm, there is that, but you can also get fine mussels from the fish market area of Brussles, washed down with a very rasperberry beer. Now where did I put those flight tickets to Brussels.......
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
Wim Gielis
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

Post by Wim Gielis »

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 :-D
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
User avatar
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

Post by jim wood »

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 :-D
Where's the like button on this site when you need it???
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
declanr
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

Post by declanr »

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 :-D
Does this suggest that TM1 isn't one of the nice things in life? :o
Declan Rodger
Wim Gielis
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

Post by Wim Gielis »

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.
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
Post Reply