Measure factory

• US 10,671,956 B2
• Filed: 12/28/2017
• Issued: 06/02/2020
• Est. Priority Date: 06/05/2012
• Status: Active Grant

• Current Assignee: Dimensional Insight Incorporated
• Original Assignee: Dimensional Insight Incorporated
• Inventors: Clark, James, Powers, Frederick A., Jablonski, Daniel J., Gorman, Matthew J., Dealy, George M.
• Primary Examiner(s): Ho, Ruay
• Application Number:
  US15/856,512
• Publication Number:
  US 20180121855A1
• Time in Patent Office: 887 Days
• Field of Search: 715708, 705 725, 705 35, 187382
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/06316 Sequencing of tasks or work
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling

Abstract

A measure factory for generating analytic measures includes data sets representing business activities arranged as columnar arrays with each column being associated with a distinct source rule that applies to the column when it is used as a data source. The measure factory includes factory rules that govern which operations on available data sources may be executed under what conditions in the measure factory, such as by taking into account the source rules and other applicable factory rules. A factory rule execution hierarchy governs the execution of ready factory rules that lack dependency on other factory rules before executing ready factory rules that have dependency on other factory rules. A script generation facility generates a script to process the plurality of factory rules according to the factory rule execution hierarchy.

Claims

1. A computer-implemented measure factory setup user interface, comprising:

a source rule definition interface for defining an operation of data set source rules, wherein the operation of at least one of the data set source rules is responsive to the defining and occurs prior to operation of a factory rule the operation of which is dependent on completion of the operation of the at least one of the data set source rules, the defining further to associate source data on which source rules operate with a plurality of columns of at least one columnar data set;

a factory rule definition interface for defining an operation of factory rules upon data in the at least one columnar data set including an order of operation of a portion of the factory rules on a least a portion of the plurality of columns, the operation of the factory rules further constrained by a factory rule operation hierarchy that is independent of the defined order of operation, the factory rules further govern at least one of extraction, transformation, computation, and loading of data within the plurality of columns of the at least one columnar data set;

a display configuration interface for configuring user-selectable dimensions within the columnar data sets around which a user interface is arranged for viewing measures of the data in the at least one columnar data set, the measures calculated through operation of at least one of the defined data set source rules that operates on data indicated by at least one of the configured user-selectable dimensions and through operation of at least one of the defined factory rules, each of the measures having a measure type; and

a measure selection interface for selecting types of measures that are produced by the measure factory, the measures of the selected types of measures being presented in the user interface for viewing measures of the data.

2. The computer-implemented measure factory setup user interface of claim 1, wherein the source data characterizes a business operation of a business.

3. The computer-implemented measure factory setup user interface of claim 1, wherein defining factory rules is independent of a presence of data processed by factory rules.

4. The computer-implemented measure factory setup user interface of claim 1, wherein the factory rule definition interface facilitates defining an order of factory rule execution.

5. The computer-implemented measure factory setup user interface of claim 1, wherein the factory rule definition interface facilitates configuring an effectivity date for at least a portion of the factory rules.

6. The computer-implemented measure factory setup user interface of claim 1, wherein factory rule definition interface facilitates defining a target date for execution of at least a portion of the factory rules.

7. The computer-implemented measure factory setup user interface of claim 1, further comprising a measure definition interface for configuring measures as relationships of the defined source rules and factory rules.

8. The computer-implemented measure factory setup user interface of claim 7, wherein the measure definition interface comprises a visual indicator of a trend of a measure as one of a positive trend and a negative trend.

9. The computer-implemented measure factory setup user interface of claim 1, wherein selecting types of measures includes identifying at least one of factory rules, source rules, and dimensions of the data.

10. A computer-implemented method that facilitates defining a measure factory comprising:

defining an operation of data set source rules that associate data within a plurality of columns of a columnar data set;

defining an operation of factory rules that govern at least one of extraction, transformation, computation, and loading of data of the columnar data set;

defining user-selectable dimensions within the data set around which a user interface for viewing an output of the measure factory is arranged; and

defining measures that are presented in the user interface.

11. A computer-implemented method of measure factory setup, comprising:

defining an operation of data set source rules, wherein the operation of at least one of the data set source rules is responsive to the defining and occurs prior to operation of a factory rule the operation of which is dependent on completion of the operation of the at least one of the data set source rules;

associating source data with a plurality of columns to define a columnar data set based on the operation of data set source rules;

defining an operation of factory rules upon data in the columnar data set including an order of operation of a portion of the factory rules on a least a portion of the plurality of columns, the operation of the factory rules further constrained by a factory rule operation hierarchy that is independent of the defined order of operation;

governing at least one of extraction, transformation, computation, and loading of data within the columnar data set responsive to the operation of factory rules;

configuring user-selectable dimensions within the columnar data set around which a user interface is arranged for viewing measures of the data calculated from the columnar data set that are output by a measure factory; and

selecting measures produced by the measure factory that are presented in the user interface for viewing measures of the data.

12. The computer-implemented method of claim 11, wherein facilitating selection of types of measures includes facilitating identifying at least one of factory rules, source rules, and dimensions of the data.

13. The computer-implemented method of claim 11, wherein the source data characterizes a business operation of a business.

14. The computer-implemented method of claim 11, wherein governing at least one of extraction, transformation, computation, and loading factory rule execution is independent of a presence of data processed by factory rules.

15. The computer-implemented method of claim 11, wherein the governing at least one of extraction, transformation, computation, and loading is further dependent on an order of factory rule execution.

16. The computer-implemented method of claim 11, wherein the governing at least one of extraction, transformation, computation, and loading is based on an effectivity date for at least a portion of the factory rules.

17. The computer-implemented method of claim 11, wherein the governing at least one of extraction, transformation, computation, and loading is based on a target date for execution of at least a portion of the factory rules.

18. The computer-implemented method of claim 11, wherein the measures produced by the measure factory are based on relationships of the source rules and factory rules.

19. The computer-implemented method of claim 11, further comprising:

viewing measures of the data in the at least one columnar data set, the measures calculated through operation of at least one of the defined data set source rules that operates on data indicated by at least one of the configured user-selectable dimensions and through operation of at least one of the defined factory rules, each of the measures having a measure type.