Patent ID: 7720831

Claim:
A computer-readable storage medium including executable instructions which, when executed, manage data by: receiving an input defining a number of writeable regions of a multi-dimensional data store; creating metadata associated with the defined number of writeable regions, the metadata corresponding to a number of writeable sub-cubes of the multi-dimensional data store, the number of writeable sub-cubes defined in part by a scope operator representative of a collection of sub-cubes of the multi-dimensional data store; receiving data that corresponds with at least one of the number of writeable regions; translating the received data into a relational representation based in part on the created metadata; determining the created metadata is valid; storing validated metadata to relational tables of a relational store component; communicating multi-dimensional role permissions and role-user associations from the relational store component to the multi-dimensional store component; performing a security check, thereby determining a writeback permission exists for a writeable sub-cube including using security tables for each sub-cube dimension; and, processing the received data for validated metadata and writeback permission including rebuilding associated data and aggregations by re-reading from the relational store component and calculating the associated aggregations.