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.
Element Security Override
- 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
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Another option is to create a CellSecurity cube for those cubes that use the department dimension differently and apply your security there.
- PavoGa
- MVP
- Posts: 617
- 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
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
Cleveland, TN
-
- Posts: 22
- Joined: Tue Mar 31, 2015 9:54 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Element Security Override
Thanks guys. I settled with some rules in the element security control cube.