Patent ID: 8484247

Claim:
A system for securing and authorizing access to multidimensional transactional data, comprising: an online analytical processing (OLAP) system that implements an OLAP application computer program for accessing the multidimensional transactional data, the OLAP system including: a storage system that stores authorization information, wherein the authorization information defines an authorization for a user, and a processor system that executes the OLAP application computer program; and a database system that implements a database that stores the multidimensional transactional data, wherein the OLAP application computer program controls the OLAP system to execute processing including: accessing a selection of the multidimensional transactional data from the database system according to a multidimensional request from the user, aggregating the selection of the multidimensional transactional data according to the multidimensional request, to form aggregated information, filtering the selection of the multidimensional transactional data according to the authorization for the user, to form a filtered selection, wherein the selection consists of the filtered selection and data omitted from the filtered selection, wherein an aggregation of the filtered selection differs from the aggregation information, and wherein the filtered selection differentiates between authorized data, unauthorized data, and absent data according to the authorization of the user, and providing to the user the filtered selection, an indicator for the data omitted from the filtered selection, and the aggregated information.