Element level security not working

Post Reply
kaazimraza
Posts: 95
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.2.2
Excel Version: 2016

Element level security not working

Post by kaazimraza »

Hi guys,

i am experimenting a business scenario and have created a few dimensions and a cube to test the security. I want to hide a particular element from the user. So I went to Dimension > Element Level Security and set the access rights to NONE for element & group combination. But when I access the cube using the test user which is part of the group I have set the access to NONE, I can still see and edit the values for that particular element. Am I doing something incorrect? Or maybe missing something?

Thanks

Kaz
Attachments
cube view
cube view
activity-cube-values-test-user.png (2.59 KiB) Viewed 5440 times
Element security assignments
Element security assignments
actiivt-dim-security.png (2.9 KiB) Viewed 5440 times
Security cube values
Security cube values
activity-dim-security-group.png (3.42 KiB) Viewed 5440 times
Thanks,

Kaz
Wim Gielis
MVP
Posts: 3240
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: Element level security not working

Post by Wim Gielis »

Hello

You don't have CellSecurity implemented ?
Can you show us a screenshot of the box when you do "Who am I" on the TM1 server name in Perspectives or Architect ?
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
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Element level security not working

Post by mvaspal »

HI Wim,

I think the NONE element security setting is not overwritten with a WRITE cell security setting. At least I am using this property quite often that once NONE is set on element level, we do not have to care about that on cell level.
kaazimraza
Posts: 95
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.2.2
Excel Version: 2016

Re: Element level security not working

Post by kaazimraza »

Hi Wim,

Here are the screen shots of Who Am I result and the server side user & group as well. These confirm that we are looking at the correct user groups.

For the cell security bit, I wouldn't imagine that I'll have to create a cell security cube just to hide a single element of dimension? I mean, wouldn't we use cell security to hide a specific combination of elements across all dimensions?

Thanks

Kaz
Attachments
Who Am I result
Who Am I result
test-user-who-am-i.png (3.2 KiB) Viewed 5432 times
user shown in who-am-i and its association with the use rgroup
user shown in who-am-i and its association with the use rgroup
server-side-user-group.png (1.12 KiB) Viewed 5432 times
Thanks,

Kaz
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: Element level security not working

Post by sachin »

Can you post screen which shows,
  1. The groups Cognosuser5 belongs to?
  2. Those groups' rights on the dimension in questions?

I could be wrong, however my suspect is that, Cognosuser5 is also mapped to "EveryOne" group; which must have higher permission.
Check out my blog for some good information on TM1, SPSS
kaazimraza
Posts: 95
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.2.2
Excel Version: 2016

Re: Element level security not working

Post by kaazimraza »

Hi Sachin,

Thanks for pointing me in the right direction. It was not the 'Everyone' group but another group that was causing the grief. Thanks.
Thanks,

Kaz
Post Reply