Iterative measures

• US 9,195,690 B2
• Filed: 06/26/2013
• Issued: 11/24/2015
• Est. Priority Date: 06/26/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Wilking, Michael, Dipper, Stefan, Schroetel, Sebastian
• Primary Examiner(s): NGUYEN, KIM T
• Application Number:
  US13/927,498
• Publication Number:
  US 20150006588A1
• Time in Patent Office: 881 Days
• Field of Search: 707/791, 707/802
• US Class Current: 1/1
• CPC Class Codes: G06F 16/211 Schema design and management

Abstract

A system includes determination of a dimension over which to iterate, determination of a first measure for which an aggregated value is determined per iteration, determination of a second measure for which a value is determined once per calculation of an iterative measure and against which to compare the aggregated value per iteration, and storage of the dimension, the first measure and the second measure as metadata of an iterative measure.

Claims

1. A computing system comprising:

a data storage device;

a memory storing processor-executable program code; and

a processor to execute the processor-executable program code in order to cause the computing system to;

determine a dimension over which to iterate, wherein the dimension is a time dimension;

determine a first measure for which an aggregated value is determined per iteration, wherein the first measure is a demand measure;

determine a second measure for which a value is determined once per calculation of an iterative measure, wherein the second measure is stock;

determine an operator for comparison of the aggregated value against the second measure per iteration;

determine an aggregation rule; and

store the dimension, the first measure, the second value, the operator and the aggregation rule as metadata to define the iterative measure.

2. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:

determine a dimension over which to iterate, wherein the dimension is a time dimension;

determine a first measure for which an aggregated value is determined per iteration, wherein the first measure is a demand measure;

determine a second measure for which a value is determined once per calculation of an iterative measure, wherein the second measure is stock;

determine an operator for comparison of the aggregated value against the second measure per iteration;

determine an aggregation rule; and

store the dimension, the first measure, the second value, the operator and the aggregation rule as metadata to define the iterative measure.

3. A computer-implemented method comprising:

determining a dimension over which to iterate, wherein the dimension is a time dimension;

determining a first measure for which an aggregated value is determined per iteration, wherein the first measure is a demand measure;

determining a second measure for which a value is determined once per calculation of an iterative measure, wherein the second measure is stock;

determining an operator for comparison of the aggregated value against the second measure per iteration;

determining an aggregation rule; and

storing the dimension, the first measure, the second measure, the operator and the aggregation rule as metadata to define the iterative measure.