Element Security Override

Post Reply
tm1green
Posts: 22
Joined: Tue Mar 31, 2015 9:54 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Element Security Override

Post by tm1green »

Guys,

I have element security set up for the department dimension. However, I do not want the element security to apply when the department dimension is used in some cubes. How do I go about setting this up?

Thanks in advance.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Element Security Override

Post by Alan Kirk »

In my humble the easiest way of doing this is to use a clone of the dimension in the other cubes. There are processes in the Bedrock library which can handle the cloning (including attributes) and which can be scheduled as chores.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
tomok
MVP
Posts: 2831
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: Element Security Override

Post by tomok »

Another option is to create a CellSecurity cube for those cubes that use the department dimension differently and apply your security there.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: Element Security Override

Post by PavoGa »

Alan Kirk wrote: Thu Oct 25, 2018 10:35 am In my humble the easiest way of doing this is to use a clone of the dimension in the other cubes. There are processes in the Bedrock library which can handle the cloning (including attributes) and which can be scheduled as chores.
What about Data Reservations? They seem simple enough to apply and manage, although I would only use them to temporarily apply security. In the OP's case, I'd go with separate dimensions or hierarchies (PA).

Just curious as to thoughts on Data Reservations.
Ty
Cleveland, TN
tm1green
Posts: 22
Joined: Tue Mar 31, 2015 9:54 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Element Security Override

Post by tm1green »

Thanks guys. I settled with some rules in the element security control cube.
Post Reply