Cell Security Control Cube Not Work

Post Reply
chonlanotr
Posts: 8
Joined: Thu Feb 21, 2013 11:27 am
OLAP Product: TM1, SAP BW
Version: 9.5.2
Excel Version: Excel 2010

Cell Security Control Cube Not Work

Post by chonlanotr »

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.
Edward Stuart
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

Post by Edward Stuart »

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
User avatar
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

Post by paulsimon »

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
chonlanotr
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

Post by chonlanotr »

Thanks all of you. My user has ADMIN role. If I change to user define role, it work properly.
tomok
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

Post by tomok »

chonlanotr wrote:Thanks all of you. My user has ADMIN role. If I change to user define role, it work properly.
Admins can see and do anything in TM1 regardless of whatever security you have defined.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
chonlanotr
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

Post by chonlanotr »

Thanks everybody.
Post Reply