Automated Domain Determination in Business Logic Applications

• US 20080172287A1
• Filed: 01/17/2007
• Published: 07/17/2008
• Est. Priority Date: 01/17/2007
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Hulen, Corey, Lim, Chen-I, Tien, Ian, Tomai, Catalin
• Application Number:
  US11/624,122
• Publication Number:
  US 20080172287A1
• Time in Patent Office: Days
• US Class Current: 705/10
• CPC Class Codes: G06Q 10/04 Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem" market predictions or forecasting for commercial activities G06Q30/0202
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations

Abstract

Data ranges (domains) for statistical analysis of performance metrics are determined automatically based on user inputs for ending and starting periods. User interfaces are provided with allowances for addressing missing data in a consistent manner and for creating analyties over different time domains such as fiscal and Gregorian calendar measurements. Previews of analysis may be provided for visualization of data range parameter selections. Selections may be made explicitly or dynamically using textual or graphical user interface elements.

Claims

1. A method to be executed at least in part in a computing device for automatically determining a domain for a performance metric based analysis, the method comprising:

receiving a user indication of an ending period for the domain,

receiving a user indication of a starting period for the domain,

automatically determining a granularity for the domain,

automatically determining the domain based on the starting period, the ending period, and the granularity;

receiving a user indication for at least one exclusion period; and

automatically adjusting the domain based on the at least one exclusion period.

2. The method of claim 1, further comprising:

providing the user a selection option for indicating the ending period by one of;

an explicit specification and a dynamic specification.

3. The method of claim 2, wherein the selection option for the explicit specification includes selection from one of a collapsible tree listing, a list of values, a textual representation of intended selection, and a standard calendar control.

4. The method of claim 2, wherein the selection option for the dynamic specification includes selection from one of a current period, a previous period, and a next period.

5. The method of claim 4, further comprising:

determining an ending period based on at least one from a set of;

detecting a last non-empty member of a specific dimension, detecting an attribute associated with a member from the data store, and receiving input about the period as a parameter to be determined at a later time.

6. The method of claim 1, further comprising:

providing the user a selection option for indicating the starting period by one of;

an explicit specification and a dynamic lag period specification.

7. The method of claim 1, further comprising:

determining an actual lag period from the user specified dynamic lag period by one of;

approximating based on child levels of lag periods, defining based on a lag period attribute, and computing based on calendar.

8. The method of claim 1, further comprising:

determining a granularity level of the starting period from a granularity level of the ending period.

9. The method of claim 1, wherein a granularity level of the ending period is different from a granularity level of the starting period.

10. The method of claim 9, further comprising:

automatically determining the granularity of the domain by scaling the granularity levels of the starting period and the ending period.

11. The method of claim 1, further comprising:

providing the user a selection option for indicating at least one of the starting period and the ending period by adjusting a position of a slider along a time axis graphic.

12. The method of claim 1, further comprising:

receiving a user selection of a performance metric to be analyzed;

receiving a user selection of an output;

performing the analysis based on the selected performance metric and the domain; and

providing the output based on the selected output.

13. The method of claim 12, wherein the output includes at least one from a set of:

a chart, a grid, and a three dimensional visualization.

14. The method of claim 12, wherein the output is selected from available outputs based on an attribute of performance metric data.

15. A system for automatically determining a domain for a performance metric based analysis, comprising:

a memory;

a processor coupled to the memory, wherein the processor is configured to execute instructions to perform actions including;

provide a selection option for indicating an ending period for the domain by one of;

an explicit specification and a dynamic specification;

receive a user indication of the ending period;

provide a selection option for indicating a starting period for the domain by one of;

an explicit specification and a lag period specification;

receive a user indication of the starting period;

determine a granularity for the domain based on granularity levels of the starting period and the ending period;

determine the domain based on the starting period, the ending period, and the granularity;

receive a user indication for at least one exclusion period; and

adjust the domain based on the at least one exclusion period.

16. The system of claim 15, wherein the processor is further configured to determine the granularity of the domain also based on a granularity of data associated with a selected performance metric.

17. The system of claim 15, wherein the processor is further configured to provide a selection option for indicating the at least one exclusion period by one of selecting from a collapsible tree list, explicit entry, and graphic selection.

18. The system of claim 15, wherein the processor is further configured to determine a summary value for the performance metric based on an average of periods in the domain.

19. A computer-readable storage medium with instructions stored thereon for automatically determining a domain for a performance metric based analysis, the instructions comprising:

receiving a user selection of a performance metric to be analyzed,

in response to providing a user interface for indicating an ending period for the domain by one of;

an explicit specification and a dynamic specification, receiving a user indication of the ending period;

in response to providing a user interface for indicating a starting period for the domain by one of;

an explicit specification and a lag period specification, receiving a user indication of the starting period;

determining a granularity for the domain based on granularity levels of the starting period and the ending period;

determining the domain based on the starting period, the ending period, and the granularity;

in response to receiving a user indication for an exclusion period, adjusting the domain based on the received exclusion period;

receiving a user selection of an output type;

performing the analysis based on a selected performance metric and the domain; and

providing the output based on the selected output type.

20. The computer-readable storage medium of claim 19, wherein the instructions further comprise providing a preview of the analysis that is updated automatically in response to receiving one of a starting period selection and an ending period selection.