Patent ID: 7743071

Claim:
A computer-readable storage medium including executable instructions which, when executed, manage data by: receiving an input including an identifier associated with a user role, wherein the user role defines data transaction permissions associated with a multi-dimensional data store; capturing metadata associated with the data transaction permissions, wherein the metadata corresponds with the user role and identifies the data transaction permissions associated with the multi-dimensional data store, wherein the captured metadata corresponds to a dimension, hierarchy, a model, and a security scope setting that includes an intersection scope operator, union scope operator, and a negation scope operator used to define scopes, wherein to be writeable, a multi-dimensional coordinate has to be included in at least one of the scopes represented by the union scope operator, in each of the scopes represented by the intersection scope operator, and not be present in any of the scopes represented by the negation scope operator; validating and saving the validated metadata to relational tables including dimension tables, hierarchy tables, user tables, roles tables, user-role association tables, and security related tables; and presenting a number of writeable regions and non-writeable regions of a multi-dimensional data store based in part on an examination of the metadata to determine the data transaction permissions associated with multi-dimensional data in the multi-dimensional data store, the presenting including graphically displaying the number of writeable regions to designate a number of writeable sub-cubes of the multi-dimensional data store that inform an associated user of writeable cube dimensions based in part on a particular model and the user role, the number of writeable sub-cubes including writable dimension members of the multi-dimensional data store.