9.1 Security Setup Question

Post Reply
rfielden
Posts: 122
Joined: Wed Aug 06, 2008 2:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: Tega Cay, SC

9.1 Security Setup Question

Post by rfielden »

We have a select group of financial users that have access to all cost centers for financial reporting. As the cost center dimension is part of our 'payroll' cube, and even though those users don't have rights to the payroll cube, they are able to access all payroll cube data due to the cost center. Is there anyway within the security environment of Applix to control this?
User avatar
kielmc
Posts: 22
Joined: Tue Jun 24, 2008 6:17 pm
OLAP Product: TM1
Version: 10.2.2 FP4
Excel Version: 2013
Location: Birmingham, AL

Re: 9.1 Security Setup Question

Post by kielmc »

We have a select group of financial users that have access to all cost centers for financial reporting. As the cost center dimension is part of our 'payroll' cube, and even though those users don't have rights to the payroll cube, they are able to access all payroll cube data due to the cost center. Is there anyway within the security environment of Applix to control this?
If this user group has "NONE" access assigned to the payroll cube, they should not be able to see / access the cube at all, regardless of the element level security assignments in the cost center dimension.
rfielden
Posts: 122
Joined: Wed Aug 06, 2008 2:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007
Location: Tega Cay, SC

Re: 9.1 Security Setup Question

Post by rfielden »

Clarification: Some users do have access to payroll cube to allow updates related to the planning process. Is there anyway to limit this by cost center even though they have access to all cost centers for financial reporting purposes?
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: 9.1 Security Setup Question

Post by lotsaram »

rfielden wrote:Clarification: Some users do have access to payroll cube to allow updates related to the planning process. Is there anyway to limit this by cost center even though they have access to all cost centers for financial reporting purposes?
The easiest way would be to maintain separate but identical cost centre dimensions for reporting vs. planning and apply different element security to each dimension.
Post Reply