Dimension Security Significance
-
- Posts: 28
- Joined: Fri Mar 06, 2015 10:07 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
Dimension Security Significance
Hello, I have a doubt about dimension security , I am just wondering whats the Significance of Dimension Security as when I tested with 'READ' ,'WRITE' or 'NONE' (blank value in '}DimensionSecurity') user is able to see and WRITE on Cube (with WRITE security on Cube), I tried looking into Dev Guide but its not clear , whats the point of configuring Dimension security ,if anyone can share thought on this would be great, thanks
-
- Posts: 18
- Joined: Wed Sep 30, 2015 12:40 pm
- OLAP Product: TM1
- Version: 9.5.2+
- Excel Version: 2007
Re: Dimension Security Significance
Setting a dimension to NONE prevents that group from opening any cube using that dimension in Cube Viewer. The other rights have to do with editing the dimension structure and attributes.
ADMIN
As far as securing data in a cube, there are really only three object rights taken into account: the rights on the cube, the rights on each element of the cell, and the cell security rights (if cell security exists and is defined for that cell).
ADMIN
- Add/Remove attributes
- Create public subsets (from READ elements) but NOT delete them (requires the user to be in either the DataAdmin or ADMIN group)
- Usual semantics of LOCK
- Usual semantics of RESERVE
- Add/Remove/Modify elements of the dimension (even for elements with NONE access set)
- Edit attributes of elements with at least WRITE access
- View the dimension
- Export the dimension
- Create/delete private subsets (elements with NONE access do not appear in the subset editor however)
- View element attributes through the attribute editor, but not actually make changes
As far as securing data in a cube, there are really only three object rights taken into account: the rights on the cube, the rights on each element of the cell, and the cell security rights (if cell security exists and is defined for that cell).
Emily Wilkins - Software Engineer
Motio, Inc.
Motio, Inc.
-
- Posts: 28
- Joined: Fri Mar 06, 2015 10:07 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
Re: Dimension Security Significance
thanks for explaination Josh, make sense to summaries READ/WRITE access doesn't affect at Cube level, it clears my doubts ,thanks