# US 8,280,896 B2 · Reporting row structure for generating reports using focus areas

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

- Number: US 8,280,896 B2
- Document ID: US8280896B2
- Status: Granted
- Kind: B2
- Application number: 11/298,933
- Filed: 2005-12-09
- Published: 2007-06-14
- Granted: 2012-10-02
- Earliest claimed: 2005-12-09
- Assignees: Microsoft Corporation
- Inventors: Xavier Chapé; Kyrylo Val; Oleksandr Nazarov; Mark Brantbjerg Madsen; Christian Honore
- Web page: https://patentgrep.com/patent/US8280896B2

## CPC

- G06Q 10/10: Office automation; Time management
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## Abstract

A method and an apparatus for generating reports and other outputs from a computer program. A user first defines a focus area, composed of chosen data types and then creates a row definition for the focus area. In defining the row definition the user defines groups and subgroups from the data represented by the focus. This definition process allows the user to generate reports from data organized in similar rows. The user has the ability to define the data to be included in the report through the use of an expression. The expression can also be used to exclude data from the report. Additional embodiments allow the user to verify the use of data and if the data has been used multiple times, and to capture on the output the missings and duplicates.

## Claims

### Claim 1

A computer-implemented method for generating reports from data in an enterprise resource program, the computer-implemented method comprising:
defining at least one focus area in the data comprising:
displaying a list of available dimensions in the data relating to different data topics in the enterprise resource program;
receiving user input selecting one or more of the displayed available dimensions in the data corresponding to one or more selected data topics in the enterprise resource program; and
defining the at least one focus area as a composite of data elements based on the selected one or more of the displayed available dimensions in the data;
after the at least one focus area has been defined, generating a multilevel row definition provided in a multilevel view within a user interface display, wherein the generating the multilevel row definition comprises:
receiving user input that defines a user defined group within the defined at least one focus area;
receiving user input that defines a sub-group within the user defined group, the defined sub-group comprising an intermediate level branch in the multilevel row definition; and
receiving user input that defines an element type row comprising the intermediate level branch under the defined sub-group, the defined element type row including filter criteria for generating output values; and
generating a report using a processor of a computer based upon the generated multilevel row definition.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, wherein the generating the multilevel row definition further comprises:
identifying at least one user defined group as a calculation group; and
performing a desired calculation on the calculation group.

### Claim 3 (depends on 2)

The computer-implemented method of claim 2, wherein the identifying the calculation group, comprises:
identifying selected rows in the at least one user defined group as operands.

### Claim 4 (depends on 1)

The computer-implemented method of claim 1, further comprising:
performing a simulation on the generated multilevel row definition.

### Claim 5 (depends on 1)

The computer-implemented method of claim 1, further comprising:
performing a check process on the generated multilevel row definition to identify any discrepancies.

### Claim 6 (depends on 5)

The computer-implemented method of claim 5, wherein the performing the check process on the generated multilevel row definition identifies any duplicate data in the generated multilevel row definition.

### Claim 7 (depends on 6)

The computer-implemented method of claim 6, further comprising:
generating an exception report for the generated multilevel row definition when the check process identifies a discrepancy.

### Claim 8 (depends on 1)

The computer-implemented method of claim 1, wherein the different data topics in the enterprise resource program comprise one or more of an account type, a department, and a cost center of an organization in the enterprise resource program.

### Claim 9 (depends on 1)

The computer-implemented method of claim 1, wherein the generating the multilevel row definition comprises inserting a sub structure type row that refers to an existing multilevel row definition which shares at least a portion of the at least one defined focus area with the multilevel row definition being generated.

### Claim 10 (depends on 1)

The computer-implemented method of claim 1, wherein the generated multilevel row definition includes at least one calculation type row representing a user defined calculation group, the at least one calculation type row having selected rows in the generated multilevel row definition as operands to perform a desired calculation.

### Claim 11

A computer system comprising:
a processor; and
an enterprise resource program comprising:
a database storing data;
a row reporting component that generates a multilevel reporting row structure using the processor, wherein the row reporting component is configured to:
display available dimensions relating to different data topics in the enterprise resource program;
receive user selection of one or more of the displayed available dimensions;
define a focus area as a composite of the stored data within the database based on the selected one or more of the displayed available dimensions;
receive user input through a user interface that defines a user defined group within the defined focus area;
receive user input that defines a sub-group within the user defined group;
receive user input that defines a calculation row within the defined sub-group, the defined calculation row identifying rows in the generated multilevel reporting row structure as operands to perform a desired calculation; and
display the user defined group, the defined sub-group, and the defined calculation row in a multilevel view; and
an output generator that generates a report comprising output data from the database based on the generated multilevel reporting row structure.

### Claim 12 (depends on 11)

The computer system of claim 11, wherein the operands used to perform the desired calculation are displayed in the user interface when the defined calculation row is exploded.

### Claim 13 (depends on 11)

The computer system of claim 11, wherein a check process is performed on the generated multilevel reporting row structure to identify any discrepancies in the generated multilevel reporting row structure and any duplicate data in the generated multilevel reporting row structure.

### Claim 14 (depends on 11)

The computer system of claim 11, wherein the different data topics in the enterprise resource program comprise one or more of an account type, a department, and a cost center of an organization in the enterprise resource program.

### Claim 15

An Enterprise Resource Planning (ERP) system comprising:
a database storing data elements in the ERP system;
at least one user interface comprising:
a dimension field for displaying a list of available dimensions related to data topics in the database;
at least one focus field, for displaying one or more focus areas; and
at least one row definition field for displaying one or more defined multilevel row definitions; and
a computer processor that:
receives, through the at least one user interface, user input selecting a dimension from the displayed list of available dimensions;
defines a focus area as a composite of the data elements stored in the database based on the selected dimension;
receives, through the at least one user interface, user input defining groups and sub-groups within the defined focus area that include filter criteria for generating output values from the data elements stored in the database;
generates a multilevel row definition based on the defined groups and the defined sub-groups;
displays the defined focus area for selection in the at least one focus field;
displays the generated multilevel row definition for selection in the at least one row definition field;
receives user selection of the defined focus area displayed in the at least one focus field and user selection of the generated multilevel row definition displayed in the at least one row definition field; and
generates a report that comprises the data elements in the database and is based on the selected defined focus area and the selected generated multilevel row definition.

### Claim 16 (depends on 15)

The Enterprise Resource Planning (ERP) system of claim 15, the at least one focus field comprising:
a main focus field receiving selection of a main focus area; and
a secondary focus field receiving selection of a secondary focus area.

### Claim 17 (depends on 16)

The Enterprise Resource Planning (ERP) system of claim 16, the at least one row definition field comprising:
a main row definition field corresponding to the main focus field; and
a secondary row definition field corresponding to the secondary focus field.

### Claim 18 (depends on 15)

The Enterprise Resource Planning (ERP) system of claim 15, the at least one user interface comprising:
a first user interface that:
displays the dimension field; and
a second user interface that:
receives the user input defining the groups and the sub-groups within the defined focus area, wherein rows within the multilevel row definition are generated based on the defined groups and the defined sub-groups.

### Claim 19 (depends on 18)

The Enterprise Resource Planning (ERP) system of claim 18, the second user interface receiving user input that:
identifies at least one group as a calculation group; and
performs a desired calculation on the calculation group.

### Claim 20 (depends on 18)

The Enterprise Resource Planning (ERP) system of claim 18, the second user interface receiving user input that:
defines expressions for populating the defined groups within the generated multilevel row definition with the data elements from within the defined focus area that are arranged in similar rows in the database, the expressions defining which rows of the data elements in the database are included in the defined groups and which rows of the data elements in the database are excluded from the defined groups.
