# US 2019/0171652 A1 · Methods and systems for multi-dimensional aggregation using composition

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

- Number: US 2019/0171652 A1
- Document ID: US20190171652A1
- Status: Published application
- Kind: A1
- Application number: 16/272,296
- Filed: 2019-02-11
- Published: 2019-06-06
- Earliest claimed: 2012-06-29
- Assignees: Open Text Corporation
- Applicants: Open Text Corporation
- Inventors: Igor Makhlin; Alex Vladmir Popovich; Raman Walia; Boris Grinblat; Nathaniel Davidson; Uri Kochavi
- Web page: https://patentgrep.com/patent/US20190171652A1

## CPC

- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 9/3895: {for complex operations, e.g. multidimensional or interleaved address generators, macros}
- G06F 16/244: {Grouping and aggregation}
- G06F 16/24556: {Aggregation; Duplicate elimination}
- G06F 17/175: {of multidimensional data}
- G06Q 10/067: Enterprise or organisation modelling
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- 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

Multi-dimensional aggregation using user interface workflow composition is described. A determination is made whether aggregation is complete for each level of a multi-dimension aggregation. Data is retrieved for a level of aggregation in response to a determination that aggregation is not complete for each level of the multi-dimension aggregation. The data is aggregating based on the level of aggregation. The aggregated data is stored for a next level of aggregation. The data for a final level of aggregation is output to a user interface in response to a determination that aggregation is complete for each level of the multi-dimension aggregation.

## Claims

### Claim 1

A system for multi-dimensional aggregation using user interface workflow composition, the system comprising:
a processor;
a non-transitory computer readable medium storing a set of instructions executable by the processor to provide a server application configured to:
based on a request from a client to apply an aggregation function selected from a plurality of functions to a selected parent object related to children objects:
determine a number of levels for multi-dimensional aggregation associated with the selected parent object, wherein each level of the multi-dimensional aggregation is based on a corresponding level of the selected parent object to the children objects;
for each level of the multi-dimensional aggregation from a first level to a penultimate level of multi-dimensional aggregation, retrieve data to be aggregated for that level for each parent object in a next level of multi-dimensional aggregation, aggregate the retrieved data corresponding to each parent object in the next level of the multi-dimensional aggregation to generate aggregated data for that level and output the aggregated data for that level for use in the next level of multi-dimensional aggregation; and
for a final level of multi-dimensional aggregation, retrieve data to be aggregated for the final level, the data to be aggregated for the final level comprising data of the selected parent object and aggregated data output from the penultimate level, generate aggregated data for the final level of multi-dimensional aggregation and output the aggregated data for the final level of multi-dimensional aggregation to the user interface.

### Claim 2 (depends on 1)

The system for multi-dimensional aggregation of claim 1, wherein the data to be aggregated for the first level of multi-dimensional aggregation comprises non-aggregated data.

### Claim 3 (depends on 1)

The system of multi-dimensional aggregation of claim 1, wherein the first level is the penultimate level.
