Unified reporting

• US 20060200484A1
• Filed: 03/07/2005
• Published: 09/07/2006
• Est. Priority Date: 03/07/2005
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Munshi, Rajesh M., Padisetty, Sivaprasad V., Tare, Kailas Gangadhar
• Granted Patent: US 7,383,279 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/345 Summarisation for human users
• CPC Class Codes: Y10S 707/958 Data cubes
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A framework is provided that uniformly stores in a central repository data collected from various locations in an enterprise computing network. One or more measurements for data of interest in the central repository are pre-calculated. The pre-calculated measurement(s) are normalized to reflect the relative importance of the data of interest in comparison to other data in the central repository. Reports may be generated based on the pre-calculated measurements for the data of interest.

Claims

1. A system for generating reports based on data existing in an enterprise computing network, comprising:

one or more central repositories, each of which uniformly stores data existing in the enterprise computing network;

one or more unified reporting cubes, each of which pre-calculates one or more measurements for data of interest in a central repository; and

a unified reporting user interface for generating a report based on one or more pre-calculated measurements in a unified reporting cube.

2. The system of claim 1, further comprising a plurality of data stores in the enterprise computing network, wherein the plurality of data stores supply data for the one or more central repositories.

3. The system of claim 2, wherein the central repository specifies one or more data stores that supply data to the central repository.

4. The system of claim 3, further comprising a crawler service that continuously collects data from the one or more data stores and stores the data in the central repository.

5. The system of claim 1, wherein a unified reporting cube normalizes a pre-calculated measurement for the data of interest to reflect the importance of the data of interest relative to other data in the central repository.

6. The system of claim 1, further comprising a unified reporting cube administration user interface for defining a unified reporting cube.

7. The system of claim 1, the unified reporting user interface has access to all available unified reporting cubes in the enterprise computing network.

8. A computer-implemented method for generating reports based on data existing in an enterprise computing network, comprising:

gathering data existing in the enterprise computing network to a central repository with a single database schema;

creating one or more unified reporting cubes, each of which pre-calculates one or more measurements for data of interest in the central repository; and

generating a report based on one or more pre-calculated measurements in a unified reporting cube.

9. The computer-implemented method of claim 8, wherein gathering data existing in the enterprise computing network to a central repository with a single database schema includes:

identifying one or more data stores in the enterprise computing network that supply data to the central repository; and

collecting data from the one or more data stores and storing them in the central repository according to the single database schema.

10. The computer-implemented method of claim 9, further comprising updating the central repository according to data changes in the one or more data stores.

11. The computer-implemented method of claim 8, wherein a pre-calculated measurement for the data of interest is normalized to reflect the importance of the data of interest relative to other data in the central repository.

12. The computer-implemented method of claim 8, wherein creating one or more unified reporting cubes includes:

identifying data of interest in the central repository;

calculating one or more measurements for the data of interest; and

storing the calculated measurements.

13. A computer-readable medium containing computer-executable instructions for generating reports based on data existing in an enterprise computing network, comprising:

gathering data existing in the enterprise computing network to a central repository with a single database schema;

creating one or more unified reporting cubes, each of which pre-calculates one or more measurements for data of interest in the central repository; and

generating a report based on one or more pre-calculated measurements in a unified reporting cube.

14. The computer-readable medium of claim 13, wherein gathering data existing in the enterprise computing network to a central repository with a single database schema includes:

identifying one or more data stores in the enterprise computing network that supply data to the central repository; and

collecting data from the one or more data stores and storing them in the central repository according to the single database schema.

15. The computer-readable medium of claim 14, further comprising updating the central repository according to data changes in the one or more data stores.

16. The computer-readable medium of claim 13, wherein a pre-calculated measurement for the data of interest is normalized to reflect the importance of the data of interest relative to other data in the central repository.

17. The computer-readable medium of claim 13, wherein creating one or more unified reporting cubes includes:

identifying data of interest in the central repository;

calculating one or more measurements for the data of interest; and

storing the calculated measurements.

18. The computer-readable medium of claim 13, wherein the data gathered to the central repository include one or more computing jobs (“

job”

) and one or more results of executing a job.

19. The computer-readable medium of claim 18, wherein the pre-calculated measurements include:

normalized number of attempted executions of a job (“

Weight”

);

normalized number of successful executions of the job (“

Passed”

); and

normalized number of failed executions of the job (“

Failed”

).

20. The computer-readable medium of claim 19, wherein the pre-calculated measurements further include any item selected from a group consisting of:

an attempt rate that is the result of ((Passed+Failed)/Weight);

a pass rate that is result of (Passed/(Passed+Failed)); and

a status code that indicates the overall performance of a job.