Methods and systems for multi-dimensional aggregation using composition

A computer program product comprising a non-transitory, computer-readable medium storing a set of instructions executable by a processor, wherein the set of instructions include instructions for:

• accessing data for a computer implemented process from a set of related data objects in a data store, each object in the set of related data objects representing an entity modelled in the process;
• receiving a request generated responsive to a user interaction in a user interface of a workflow composition tool during workflow composition, the user interaction including user selection of a set of parent objects each having a set of children objects and user selection of an aggregation function to apply a multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects, the user-selected aggregation function selected by the user from a plurality of aggregation functions selectable from the user interface;
• determining a number of levels for the multi-dimensional aggregation associated with the request, each level of the multi-dimensional aggregation representing a different dimension of data values to be aggregated,
• wherein the multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects to be applied is configured for:
• for each parent object in the set of parent objects:
• retrieving children object data for a first level of multi-level aggregation for a related set of children objects related to that parent object,
• aggregating the children object data to generate aggregated children object data for that parent object,
• and outputting the aggregated children object data for use in a second level of multi-dimensional aggregation;
• for the second level of multi-dimensional aggregation:
• applying the user-selected aggregation function to parent object data from the set of parent objects to generate a data value for a first dimension of the multi-dimensional aggregation, and
• applying the user-selected aggregation function using the aggregated children object data for each parent object to generate a data value for a second dimension of the multi-dimensional aggregation to generate a final result;
• and
• outputting the final result to the user interface, the final result including multiple dimensions of data values.

A computer-implemented method for multi-dimensional data aggregation using workflow composition, the method comprising:

• accessing data for a computer implemented process from a set of related data objects in a data store, each object in the set of related data objects representing an entity modelled in the process;
• receiving a request generated responsive to a user interaction in a user interface of a workflow composition tool during workflow composition, the user interaction including user selection of a set of parent objects each having a set of children objects and user selection of an aggregation function to apply a multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects, the user-selected aggregation function selected by the user from a plurality of aggregation functions selectable from the user interface;
• determining a number of levels for the multi-dimensional aggregation associated with the request, each level of the multi-dimensional aggregation representing a different dimension of data values to be aggregated,
• wherein the multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects to be applied is configured for:
• for each parent object in the set of parent objects:
• retrieving children object data for a first level of multi-level aggregation for a related set of children objects related to that parent object,
• aggregating the children object data to generate aggregated children object data for that parent object, and
• outputting the aggregated children object data for use in a second level of multi-dimensional aggregation;
• for the second level of multi-dimensional aggregation:
• applying the user-selected aggregation function to parent object data from the set of parent objects to generate a data value for a first dimension of the multi-dimensional aggregation, and
• applying the user-selected aggregation function using the aggregated children object data for each parent object to generate a data value for a second dimension of the multi-dimensional aggregation to generate a final result;
• and
• outputting the final result to the user interface, the final result including multiple dimensions of data values.