# US 2010/0169268 A1 · System and method of securing and authorizing multidimensional transactional data

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2010/0169268 A1
- Document ID: US20100169268A1
- Status: Published application
- Kind: A1
- Application number: 12/345,930
- Filed: 2008-12-30
- Published: 2010-07-01
- Earliest claimed: 2008-12-30
- Assignees: Sap SE
- Inventors: Peter John; Erich Marschall
- Web page: https://patentgrep.com/patent/US20100169268A1

## CPC

- G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries}
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 21/6218: {to a system of files or objects, e.g. local or distributed file system or database}
- G06F 2221/2141: Access rights, e.g. capability lists, access control lists, access tables, access matrices
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

In one embodiment the present invention includes a system for securing and authorizing access to multidimensional transactional data. The system includes online analytical processing (OLAP) system and a database system. The OLAP system accesses a selection of multidimensional transactional data from the database system according to a multidimensional request. The OLAP system aggregates the selection to form aggregated information. The OLAP system filters the selection according to the authorization for the user, to form a filtered selection. In this manner the user can see accurate aggregations yet not see unauthorized data.

## Claims

### Claim 1

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, and
providing to the user the filtered selection and the aggregated information.

### Claim 2 (depends on 1)

The system of claim 1, wherein the aggregated information aggregates all of the selection regardless of the authorization of the user.

### Claim 3 (depends on 1)

The system of claim 1, wherein the filtered selection differentiates between authorized data, unauthorized data and absent data according to the authorization of the user.

### Claim 4 (depends on 1)

The system of claim 1, wherein:
the user is a first user, the authorization is a first authorization, the filtered selection is a first filtered selection, and the aggregated information is first aggregated information;
a second user has a second authorization, wherein the second authorization provides different authorizations from the first authorization;
a second filtered selection results from filtering the selection of the multidimensional transactional data according to the second authorization;
second aggregated information results from aggregating the selection according to the multidimensional request from the second user; and
the first filtered selection differs from the second filtered selection, and the first aggregated information matches the second aggregated information.

### Claim 5 (depends on 1)

The system of claim 1, wherein the multidimensional transactional data is two-dimensional transactional data, wherein the two-dimensional transactional data includes a first plurality of master data and a second plurality of master data, and wherein an element of transactional data in the two-dimensional transactional data is associated with one of the first plurality of master data and one of the second plurality of master data.

### Claim 6 (depends on 1)

The system of claim 1, wherein the multidimensional transactional data is two-dimensional transactional data, wherein the two-dimensional transactional data includes a first plurality of master data and a second plurality of master data, wherein the authorization information indicates a first subset of the first plurality of master data and a second subset of the second plurality of master data.

### Claim 7

A computer-implemented method of securing and authorizing access to multidimensional transactional data, comprising:
accessing a selection of multidimensional transactional data according to a multidimensional request;
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 an authorization for a user, to form a filtered selection; and
outputting the filtered selection and the aggregated information.

### Claim 8 (depends on 7)

The method of claim 7, wherein the aggregated information aggregates all of the selection regardless of the authorization of the user.

### Claim 9 (depends on 7)

The method of claim 7, wherein the filtered selection differentiates between authorized data, unauthorized data and absent data according to the authorization of the user.

### Claim 10 (depends on 7)

The method of claim 7, wherein:
the user is a first user, the authorization is a first authorization, the filtered selection is a first filtered selection, and the aggregated information is first aggregated information;
a second user has a second authorization, wherein the second authorization provides different authorizations from the first authorization;
a second filtered selection results from filtering the selection of the multidimensional transactional data according to the second authorization;
second aggregated information results from aggregating the selection according to the multidimensional request from the second user; and
the first filtered selection differs from the second filtered selection, and the first aggregated information matches the second aggregated information.

### Claim 11 (depends on 7)

The method of claim 7, wherein the multidimensional transactional data is two-dimensional transactional data, wherein the two-dimensional transactional data includes a first plurality of master data and a second plurality of master data, and wherein an element of transactional data in the two-dimensional transactional data is associated with one of the first plurality of master data and one of the second plurality of master data.

### Claim 12 (depends on 7)

The method of claim 7, wherein the multidimensional transactional data is two-dimensional transactional data, wherein the two-dimensional transactional data includes a first plurality of master data and a second plurality of master data, wherein the authorization information indicates a first subset of the first plurality of master data and a second subset of the second plurality of master data.

### Claim 13

A computer program embodied on a tangible recording medium for securing and authorizing access to multidimensional transactional data, comprising:
a first computer program that accesses a selection of multidimensional transactional data according to a multidimensional request;
a second computer program that aggregates the selection of the multidimensional transactional data according to the multidimensional request, to form aggregated information;
a third computer program that filters the selection of the multidimensional transactional data according to an authorization for a user, to form a filtered selection; and
a fourth computer program that outputs the filtered selection and the aggregated information.

### Claim 14 (depends on 13)

The computer program of claim 13, wherein the aggregated information aggregates all of the selection regardless of the authorization of the user.

### Claim 15 (depends on 13)

The computer program of claim 13, wherein the filtered selection differentiates between authorized data, unauthorized data and absent data according to the authorization of the user.

### Claim 16 (depends on 13)

The computer program of claim 13, wherein:
the user is a first user, the authorization is a first authorization, the filtered selection is a first filtered selection, and the aggregated information is first aggregated information;
a second user has a second authorization, wherein the second authorization provides different authorizations from the first authorization;
a second filtered selection results from filtering the selection of the multidimensional transactional data according to the second authorization;
second aggregated information results from aggregating the selection according to the multidimensional request from the second user; and
the first filtered selection differs from the second filtered selection, and the first aggregated information matches the second aggregated information.

### Claim 17 (depends on 13)

The computer program of claim 13, wherein the multidimensional transactional data is two-dimensional transactional data, wherein the two-dimensional transactional data includes a first plurality of master data and a second plurality of master data, and wherein an element of transactional data in the two-dimensional transactional data is associated with one of the first plurality of master data and one of the second plurality of master data.

### Claim 18 (depends on 13)

The computer program of claim 13, wherein the multidimensional transactional data is two-dimensional transactional data, wherein the two-dimensional transactional data includes a first plurality of master data and a second plurality of master data, wherein the authorization information indicates a first subset of the first plurality of master data and a second subset of the second plurality of master data.
