Planning Analytics - TM1 - Security

Post Reply
Peter Picazio
Posts: 17
Joined: Sun Mar 10, 2019 9:06 pm
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: Excel version 2013

Planning Analytics - TM1 - Security

Post by Peter Picazio » Mon Jun 03, 2019 6:52 pm

We have TM1 installed on Planning Analytics 2.0
I created a new security group with access on a dimension restricted to Read Only for 6 element members within the dimension. All of the other elements (including Parents) within this dimension have None access for the security group. The user who I added to that group is able to see all members in the dimension, not just the 6 that i gave read access to.

Why wouldn't access be restricted on this dimension for the specific security group that this person is assigned to?

User avatar
macsir
Community Contributor
Posts: 617
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: Planning Analytics - TM1 - Security

Post by macsir » Mon Jun 03, 2019 8:04 pm

Did you refresh security after changing?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

Peter Picazio
Posts: 17
Joined: Sun Mar 10, 2019 9:06 pm
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: Excel version 2013

Re: Planning Analytics - TM1 - Security

Post by Peter Picazio » Mon Jun 03, 2019 9:36 pm

I refreshed security and the user can still see the all the members in the dimension

tomok
MVP
Posts: 2554
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: Planning Analytics - TM1 - Security

Post by tomok » Mon Jun 03, 2019 10:17 pm

How many other groups is the user in? What kind of access do those groups have to the dimension?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Peter Picazio
Posts: 17
Joined: Sun Mar 10, 2019 9:06 pm
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: Excel version 2013

Re: Planning Analytics - TM1 - Security

Post by Peter Picazio » Tue Jun 04, 2019 1:37 am

This user is only is this specific group, no others.

lotsaram
MVP
Posts: 3239
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Planning Analytics - TM1 - Security

Post by lotsaram » Tue Jun 04, 2019 8:04 am

Peter Picazio wrote:
Tue Jun 04, 2019 1:37 am
This user is only is this specific group, no others.
With all due respect, this categorically can't be the case. TM1 security is cumulative so the rights to the elements must be coming from another group the user belongs to.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Post Reply