Patent ID: 8538990
Filing Date: 2013-09-17
Classification: G06F

Abstract:
1. A computer-implemented method for resolving cell-level access in a multi-dimensional data structure in a database based on one or more sets of dimensional access rules, the method comprising: providing a business hierarchy, the business hierarchy including a plurality of nodes arranged in a tree structure having one or more levels; providing an online analytical processing database including a plurality of data cubes, wherein at least some of the data cubes have the business hierarchy as one of their dimensions; providing one or more rule-based access tables for controlling access to one or more cells of each data cube; identifying one or more groups of nodes in the business hierarchy that have identical access settings; generating a single access block per group of nodes, each access block being a serializable access specification object that contains information for generating a complete cell-level mask of access settings for a single node of the business hierarchy; for each node in the business hierarchy, generating the cell-level mask of access settings based on the information in the access blocks, wherein generating the cell-level access mask includes: