Cell-Level Security Definitions & Testing
While recently testing out some security changes, I discovered the new cell-level security feature and found it really useful so thought I’d share 😊 Creating Cell-Level Security Definitions The cell-level security feature was introduced as part of the March 2021 EPM patch, so deployed to Test environments on 5th March and to Production on 19th March. The new feature allows us to setup additional security down to a single cell for a selected user or group. This will be applied on top of existing dimension security and valid intersections. For each new rule, we must select the following: Users, Groups – Specify the users and/or groups to apply the rule to Restrictions – Set to either Deny Read or Deny Write to override the current dimensional security Anchor dimension – Similarly to valid intersections, when creating a new rule we must select the anchor dimension and any additional dimensions required for the combination. Then select members from each dimension to form th