PA 2.07 - }ClientProperties cube
-
- Posts: 1
- Joined: Tue Apr 14, 2020 9:44 am
- OLAP Product: Planning Analytics
- Version: PA 2.0.x
- Excel Version: Office 365
PA 2.07 - }ClientProperties cube
Hi,
i try to find an easy solution to disable client.
In the }ClientProperties dimension in the }ClientProperties cube , I found the element "IsDisabled" which seems to disable a client to login.
My problem is, that this element isn't documented any where.
Can anybody point me to the right documentation?
thanks
i try to find an easy solution to disable client.
In the }ClientProperties dimension in the }ClientProperties cube , I found the element "IsDisabled" which seems to disable a client to login.
My problem is, that this element isn't documented any where.
Can anybody point me to the right documentation?
thanks
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: PA 2.07 - }ClientProperties cube
This property seems to be new and undocumented. That it's undocumented is kinda par for the course given that ReadOnlyUser is also not documented and that has literally been there for ever https://www.ibm.com/support/knowledgece ... 7015d.html
So I wouldn't read anything into it being undocumented. But IsDisabled does seem to be new to the last few 2.0.x releases of PA. I don't recall seeing it before that but I see it is automatically added to clientProperties on all my models runnign on 11.6 and 11.7 builds.
So I wouldn't read anything into it being undocumented. But IsDisabled does seem to be new to the last few 2.0.x releases of PA. I don't recall seeing it before that but I see it is automatically added to clientProperties on all my models runnign on 11.6 and 11.7 builds.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 3117
- 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: PA 2.07 - }ClientProperties cube
To use it, set IsDisabled to 1 in the }ClientProperties cube.
Note that you cannot disable a client that is part of the built-in Admin group. The property is ignored in that case.
Note that you cannot disable a client that is part of the built-in Admin group. The property is ignored in that case.
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
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
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: PA 2.07 - }ClientProperties cube
That is interesting to know. However, this property doesn't seem to work properly at least in 2.0.9.1.
-
- MVP
- Posts: 3117
- 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: PA 2.07 - }ClientProperties cube
I should check my install on the laptop but I’m pretty confident that it is a 2.0.8. I only tested it in TM1 Perspectives.
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
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
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: PA 2.07 - }ClientProperties cube
Thanks, Wim.
I tested it as well in Perspectives but not working. Do you need to reboot the server after this change?
What does the TM1 Perspectives say after disabling? How about PAfe and PAW?
I tested it as well in Perspectives but not working. Do you need to reboot the server after this change?
What does the TM1 Perspectives say after disabling? How about PAfe and PAW?
-
- MVP
- Posts: 3117
- 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: PA 2.07 - }ClientProperties cube
For me it works. Here are screenshots.
PAL version 11.6.0.14
PAL version 11.6.0.14
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
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
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: PA 2.07 - }ClientProperties cube
FWIW, Following Wim's process on PAL 2.0.9.2 (11.8.100.13) gives me the same results as Wim's i.e. Setting disabled to 1 blocks logins.
-
- Regular Participant
- Posts: 350
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: PA 2.07 - }ClientProperties cube
Hi,
Does this affect licencing in any way? I.e. if they are disabled are they counted?
Maren
Does this affect licencing in any way? I.e. if they are disabled are they counted?
Maren
-
- MVP
- Posts: 3117
- 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: PA 2.07 - }ClientProperties cube
No idea MarenC. But in my generic TI process, I count them separately. Up to the sales colleagues to use the information or not.
I'm planning on rewriting this TI process in tm1py, curious to see how I will advance (or not).
I'm planning on rewriting this TI process in tm1py, curious to see how I will advance (or not).
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
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
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: PA 2.07 - }ClientProperties cube
Thanks, I am using CAM. Maybe that's the reason?
-
- MVP
- Posts: 3117
- 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: PA 2.07 - }ClientProperties cube
Could be possible, I don't have such an installation for testing.
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
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
- scrumthing
- Posts: 81
- Joined: Tue Jan 26, 2016 4:18 pm
- OLAP Product: TM1
- Version: 11.x
- Excel Version: MS365
Re: PA 2.07 - }ClientProperties cube
AFAIK (remerbing our license audit this year) they are explicitly asking for the isdisabled property because those users are most likely not counted.
There is no OLAP database besides TM1!
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: PA 2.07 - }ClientProperties cube
I use cam new client parameter and delete the user from }clients dim will disable the user.
-
- Posts: 139
- Joined: Tue May 21, 2019 3:33 pm
- OLAP Product: TM1
- Version: PA 2.0.x
- Excel Version: 2016
- Location: The Internet
Re: PA 2.07 - }ClientProperties cube
Thank you macsir but i'm looking for something more straightforward. I was thinking of something like "if user A is NOT in group X then disable user A".
-
- Posts: 139
- Joined: Tue May 21, 2019 3:33 pm
- OLAP Product: TM1
- Version: PA 2.0.x
- Excel Version: 2016
- Location: The Internet
Re: PA 2.07 - }ClientProperties cube
**Update**
I created a ticket couple months ago and they finally fix the issue with PA 2.0.9.6 release.
I created a ticket couple months ago and they finally fix the issue with PA 2.0.9.6 release.
https://www.ibm.com/support/pages/syste ... s_2096.pdfPH33540 TM1 server isdisabled flag permits user logins into Planning Analytics server with CAM
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: PA 2.07 - }ClientProperties cube
Thanks, good to know.