Follow these steps to create a cell security
control cube.
Procedure
- In TM1® Architect or TM1 Perspectives , right-click on the cube for which
you want to define cell-level security and then select Security, Create
Cell Security Cube.
TM1 automatically
creates a security control cube using the naming format }CellSecurity_CubeName where CubeName
is the name of the cube that you selected. For example, if you selected
the cube SalesCube, then TM1 creates
the security control cube }CellSecurity_SalesCube.
TM1 adds the dimensions of the original
cube required to set security to the newly created security control
cube, plus the }Groups dimension is added as the last dimension in
the new cube.
- Click View, Display Control
Objects if the control cubes are not already visible.
TM1 displays the new security control
cube along with the original cube.
To apply
security to cells in the security control cube, by TM1 security
group:
- Open the security control cube you just created by double-clicking
the security control cube, for example,
- Click Recalculate
to display
the security control groups, or click Options, Automatic
Recalculate.
- Expand the rows to display the cells to which you want
to assign security rights.
Note: Remember,
cell-level security applies to leaf elements.
- Enter the security level in the cube cells to assign security
rights by user group.
For details, see Assigning Security Rights to Groups.
For
example, the months in the second quarter for the Inspectors group
have security assigned as None.
- Close the security control cube.
- Save the view.
- Test the security levels by logging in as a user who is
a member of the affected security group and viewing the cube for which
you have set security.
