Hello
I have assigned cell security 'WRITE' to some of the elements and NONE to all other elements on Products Dim on Price_and_Cost Cube (Please see attached figure) for Test group, now when user 'Micky' from 'Test' ( user belong to only that group) login and navigate to the Price_and_Cost cube user can see all the elements of Products Dim (please refer to pic attached), from my understanding Cell Security 'NONE' should not allow user to see the elements at all ( like element security NONE does), though user can't see the data entered in cells, according to principle of most restrictive and cell security user should not see any element with NONE , am I missing something here,thanks
Cell Security NONE issue
-
- Posts: 28
- Joined: Fri Mar 06, 2015 10:07 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
Cell Security NONE issue
- Attachments
-
- Test Group user can see All elements of Products Dim
- Test_Group_User Access.PNG (33.14 KiB) Viewed 4023 times
-
- Cell Security Rule ( WRITE to some elements), NONE to others
- CellSecurity_Rule.PNG (93.94 KiB) Viewed 4023 times
-
- MVP
- Posts: 3185
- 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: Cell Security NONE issue
Do not forget to implement element security if you want to restrict access to the elements themselves.
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
- qml
- MVP
- Posts: 1095
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Cell Security NONE issue
Your understanding is not accurate. Cell Security will not affect which elements users can see. It only affects what cube data they can see. If you want to restrict access to dimension elements you will also need to use Element Security.mnaithan wrote:from my understanding Cell Security 'NONE' should not allow user to see the elements at all ( like element security NONE does), though user can't see the data entered in cells, according to principle of most restrictive and cell security user should not see any element with NONE , am I missing something here,thanks
Kamil Arendt
-
- Posts: 28
- Joined: Fri Mar 06, 2015 10:07 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
Re: Cell Security NONE issue
thanks for the replies, make sense to me,I would have controlled it via element security, thanks