Efficient data structures for multi-dimensional security

摘要

Efficient data structures are generated to enforce permissions on a multi-dimensional representation in a performance management application. A model site is generated having at least one model with at least one dimension. User permissions and group permissions are set for the model. The user permission and the group permissions are deployed to a relational database. A collective user permission table is generated based on the user permissions and the group permissions. Thus, an end user may receive permissions associated with a model and permissions associated with particular dimensions of a model without an inefficient consumption of resources.

主权项

1. A method for multi-dimensional security, comprising:
displaying a graphical user interface for configuring multi-dimensional security for models having dimensions that are associated with a model site, the graphical user interface configured to:
associate a group role with a model by receiving a selection of what models and what dimensions are to be associated with the group role;receive a selection for setting a group permission for the group role between a low permission and a high permission when determined;associate a user with the model and the dimensions that includes a user permission for accessing data associated with the model and the dimensions;display a permission customization selector that, when selected, enables receiving customizations to the user permission, wherein the user permission is associated with the group permission;in response to receiving the selection, store the user permission and the group permission within a relational data store;generate a collective user permissions table from the user permission and the group permission within the relational data store, wherein the collective user permissions table identifies collective user permissions based on the group permission for accessing data associated with the model and user permissions for accessing data associated with the model; andpush the collective user permissions that are stored in the relational data store to a multi-dimensional store to provide multi-dimensional security for a multi-dimensional representation.