Experts I need your help. I create Cell Security Control Cube via context menu on target cube. After that create rule on control cube to set 'READ'. But in target cube cell can be write.
What I am wrong? I run TM1 9.5.2 on local machine.
Cell Security Control Cube Not Work
-
- Posts: 8
- Joined: Thu Feb 21, 2013 11:27 am
- OLAP Product: TM1, SAP BW
- Version: 9.5.2
- Excel Version: Excel 2010
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Cell Security Control Cube Not Work
Are you logged in as Admin when viewing the target cube?
Can you check the request for assistance guidelines as this will greatly improve responses:
http://www.tm1forum.com/viewtopic.php?f=3&t=1037
Can you check the request for assistance guidelines as this will greatly improve responses:
http://www.tm1forum.com/viewtopic.php?f=3&t=1037
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Cell Security Control Cube Not Work
Hi, After you add a rule to a security cube you need to do a refresh security before the changes take effect. Right click on the server and select Security then Refresh
Regards
Paul Simon
Regards
Paul Simon
-
- Posts: 8
- Joined: Thu Feb 21, 2013 11:27 am
- OLAP Product: TM1, SAP BW
- Version: 9.5.2
- Excel Version: Excel 2010
Re: Cell Security Control Cube Not Work
Thanks all of you. My user has ADMIN role. If I change to user define role, it work properly.
-
- MVP
- Posts: 2836
- 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: Cell Security Control Cube Not Work
Admins can see and do anything in TM1 regardless of whatever security you have defined.chonlanotr wrote:Thanks all of you. My user has ADMIN role. If I change to user define role, it work properly.
-
- Posts: 8
- Joined: Thu Feb 21, 2013 11:27 am
- OLAP Product: TM1, SAP BW
- Version: 9.5.2
- Excel Version: Excel 2010
Re: Cell Security Control Cube Not Work
Thanks everybody.