security

Post Reply
aryan
Posts: 7
Joined: Fri May 04, 2018 3:39 pm
OLAP Product: oracle
Version: 10.2.2
Excel Version: 2013

security

Post by aryan »

Can we give column wise security in TM1.If so how can we give it.I can find cell level security
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: security

Post by tomok »

There is no concept of a column in TM1. If you mean dimension level security, then yes. Right click on }Dimensions object and choose Security.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: security

Post by declanr »

I assume you have a view with one of your dimensions as the columns and you want to apply security on a read/write/dont see basis to the elements (columns) you see in that dimension.
If sonyou are looking for element security, you can right click on the dimension in question and select the element security option - it will bring up a gui where you can set it accordingly. Once this is done it will also create a control cube called }elementsecurity_<yourdimname>... this is normally a bit easier to use to set your security, you just need to remember to right click on the server and refresh security after making changes (or use a TI.)

Also worth noting that if you have cell security in place that will also be taking effect.
Declan Rodger
Post Reply