Efficient data handling representations

A system to manage data comprising:

• a modeler component to define write permissions associated with a number of regions of a multi-dimensional data store, wherein the modeler component generates metadata based on the defined write permissions;
• an interface component to interact with permitted regions of the multi-dimensional data store, wherein the permitted regions are presented to distinguish writeable regions of the multi-dimensional data store;
• a data management component to manage write access to the permitted regions of the multi-dimensional data store, wherein the data management component can use a number of security definitions and associated metadata to manage write operations, wherein the 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,
• a serving component to use the validated metadata associated with an associated user as part of presenting the writeable regions and non-writeable regions to the associated user, the presenting including graphically displaying the number of writeable regions in the interface component to designate a number of writeable sub-cubes of the multi-dimensional data store that inform the associated user of writeable cube dimensions based in part on a particular model and the user role, the number of writeable sub-cubes includes writable dimension members of the multi-dimensional data store.

A method of managing data comprising:

• defining a write permission associated with a region of a multi-dimensional data store, wherein the write permission is associated with a user and an associated model;
• capturing information associated with the write permission as structural metadata, wherein the structural 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 the write permission and the structural metadata and saving the validated metadata to relational tables of a relational data store including dimension tables, hierarchy tables, user tables, roles tables, user-role association tables, and security related tables;
• and,
• presenting a distinctive representation of the region of the multi-dimensional data store associated with the write permission if the validation was successful, including presenting a number of writeable regions and non-writeable regions of the multi-dimensional data store based in part on an examination of the metadata to determine write permissions associated with multi-dimensional data, 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.