Metric catalog system

• US 9,535,970 B2
• Filed: 06/28/2013
• Issued: 01/03/2017
• Est. Priority Date: 06/28/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Mohan, Mayur Belur
• Primary Examiner(s): Beausoliel, Jr., Robert
• Assistant Examiner(s): Pham, Michael
• Application Number:
  US13/929,781
• Publication Number:
  US 20150006470A1
• Time in Patent Office: 1,285 Days
• Field of Search: 707/603
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A repository stores a metric catalog. The metric catalog represents a slice of multidimensional data source. The metric catalog includes a selected measure, at least one analysis dimension, and at least one fixed dimension. A metric catalog system exposes the metric catalog as a web service. A web service client requests to consume the metric catalog. In response to the request, the metric catalog system parses the metric catalog. Based on the parsed metric catalog, one or more queries are generated and executed. Based on the execution of the queries, values of the selected measure for the at least one analysis dimension are determined. The determined values of the selected measure for the at least one analysis dimension is returned to the web service client.

Claims

1. A computer system, the system comprising:

a processor; and

a memory in communication with the processor, the memory comprising;

a repository that stores a metric catalog, wherein the metric catalog represents a slice of a multidimensional data source, and wherein the metric catalog includes a selected measure, at least one analysis dimension, and at least one fixed dimension; and

a metric catalog system to;

parse the metric catalog;

automatically generate a plurality of queries based on the parsed metric catalog, wherein the plurality of queries further comprises a first query that generates a portion of an initial analysis view of the metric catalog, a second query generated to drill down on a member of a first analysis dimension from the at least one analysis dimension, and a third query generated to drill up on the member of the first analysis dimension from the at least one analysis dimension, and wherein the metric catalog system further to;

for a member from a plurality of members at a second level of a dimension hierarchy of the at least one analysis dimension;

map the selected measure to a column axis specification of the first query;

map the member to a row axis specification of the first query;

map the at least one fixed dimension to a slice specification of the first query;

map a data source descriptor to a cube specification of the first query; and

generate the first query according to the mappings;

automatically execute the plurality of queries on the multidimensional data source;

based on the execution of the plurality of queries, determine values of the selected measure for the at least one analysis dimension;

dynamically compare the values of the selected measure to a value of a measure target;

based on the comparison, determine a measure status for the at least one analysis dimension; and

return the values of the selected measure and the determined measure status for the at least one analysis dimension, wherein the values of the selected measure are analyzed across one or more dimensions and one or more dimension hierarchies via a graphical client, and wherein the one or more dimensions comprise the at least one analysis dimension and the at least one fixed dimension.

2. The computer system of claim 1, further to:

determine values of the selected measure for a plurality of data points of a history dimension and for the at least one analysis dimension, wherein the plurality of data points are members of the history dimension and the plurality of data points are predefined in the metric catalog;

compare the values of the selected measure for the plurality of data points according to a time order; and

determine a trend of the selected measure based on the comparison of the values of the selected measure for the plurality of data points.

3. The computer system of claim 1, wherein the metric catalog system further to:

map the selected measure to a column axis specification of the second query;

map a selected member from a second analysis dimension from the at least one analysis dimension to a row axis specification of the second query;

map the member of the first analysis dimension to a slice specification of the second query;

map the at least one fixed dimension to the slice specification of the second query;

map a data source descriptor to a cube specification of the second query; and

generate the second query according to the mappings.

4. The computer system of claim 1, wherein the metric catalog system further to:

map the selected measure to a column axis specification of the third query;

map a selected member from a second analysis dimension to a row axis specification of the third query;

map a parent of the member of the first analysis dimension to a slice specification of the third query;

map the at least one fixed dimension to the slice specification of the third query;

map a data source descriptor to a cube specification of the third query; and

generate the third query according to the mappings.

5. A computer implemented method to consume a metric catalog, the method comprising:

exposing the metric catalog as a web service, wherein the metric catalog represents a slice of a multidimensional data source, and wherein the metric catalog includes a selected measure, at least one analysis dimension, and at least one fixed dimension;

receiving a request to consume the metric catalog;

in response to the request to consume the metric catalog, parsing the metric catalog;

based on the parsed metric catalog, automatically generating a plurality of queries;

receiving a request to consume an initial analysis view;

in response to the request to consume the initial analysis view, for a member from the plurality of members at a second level of a dimension hierarchy of the at least one analysis dimension;

mapping the selected measure to a column axis specification of a first query, wherein the first query generates a portion of the initial analysis view of the metric catalog;

mapping the member to a row axis specification of the first query;

mapping the at least one fixed dimension to a slice specification of the first query;

mapping a data source descriptor to a cube specification of the first query; and

generating the first query according to the mappings;

automatically executing the plurality of queries on the multidimensional data source;

based on the execution of the plurality of queries, determining values of the selected measure for the at least one analysis dimension;

dynamically comparing the values of the selected measure to a value of a measure target;

based on the comparison, determining a measure status for the at least one analysis dimension; and

returning the values of the selected measure and the determined measure status for the at least one analysis dimension, wherein the values of the selected measure are analyzed across one or more dimensions and one or more dimension hierarchies via a graphical client, and wherein the one or more dimensions comprise the at least one analysis dimension and the at least one fixed dimension.

6. The method of claim 5, further comprising:

determining values of the selected measure for a plurality of data points of a history dimension, wherein the plurality of data points are members of the history dimension and the plurality of data points are predefined in the metric catalog;

comparing the values of the selected measure for the plurality of data points according to a time order; and

determining a trend of the selected measure based on the comparison of the values of the selected measure for the plurality of data points.

7. The method of claim 5, further comprising:

receiving a drill down request on a member of a first analysis dimension from the at least one analysis dimension;

in response to the drill down request;

mapping the selected measure to a column axis specification of a second query;

mapping a selected member from a second analysis dimension from the at least one analysis dimension to a row axis specification of the second query;

mapping the member of the first analysis dimension to a slice specification of the second query;

mapping the at least one fixed dimension to the slice specification of the second query;

mapping a data source descriptor to a cube specification of the second query; and

generating the second query according to the mappings.

8. The method of claim 5, further comprising:

receiving a drill up request on a member of a first analysis dimension from the at least one analysis dimension;

in response to the drill up request;

mapping the selected measure to a column axis specification of a third query;

mapping a member from the second analysis dimension to a row axis specification of the third query;

mapping a parent of the member of the first analysis dimension to a slice specification of the third query;

mapping the at least one fixed dimension to the slice specification of the third query;

mapping a data source descriptor to a cube specification of the third query; and

generating the third query according to the mappings.

9. A non-transitory computer readable medium storing instructions thereon, which when executed by a processor cause a computer system to:

expose a metric catalog as a web service wherein the metric catalog represents a slice of a multidimensional data source, and wherein the metric catalog includes a selected measure, at least one analysis dimension, and at least one fixed dimension;

receive a request to consume the metric catalog;

in response to the request to consume the metric catalog, parse the metric catalog;

based on the parsed metric catalog, automatically generate a plurality of queries;

receive a request to consume an initial analysis view;

in response to the request to consume the initial analysis view, for a member from a plurality of members at a second level of a dimension hierarchy of the at least one analysis dimension;

map the selected measure to a column axis specification of a first query, wherein the first query generates a portion of the initial analysis view of the metric catalog;

map the member to a row axis specification of the first query;

map the at least one fixed dimension to a slice specification of the first query;

map a data source descriptor to a cube specification of the query; and

generate the first query according to the mappings;

automatically execute the plurality of queries on the multidimensional data source;

based on the execution of the plurality of queries, determine values of the selected measure for the at least one analysis dimension;

dynamically compare the values of the selected measure to a value of a measure target;

based on the comparison, determine a measure status for the at least one analysis dimension; and

return the values of the selected measure and the measure status for the at least one analysis dimension, wherein the values of the selected measure are analyzed across one or more dimensions and one or more dimension hierarchies via a graphical client, and wherein the one or more dimensions comprise the at least one analysis dimension and the at least one fixed dimension.

10. The computer readable medium of claim 9, wherein the instructions when executed by the processor cause the computer system further to:

determine values of the selected measure for a plurality of data points of a history dimension, wherein the plurality of data points are members of the history dimension and the plurality of data points are predefined in the metric catalog.

11. The computer readable medium of claim 10, wherein the instructions when executed by the processor cause the computer system further to:

compare the values of the selected measure for the plurality of data points according to a time order; and

determine a trend of the selected measure based on the comparison of the values of the selected measure for the plurality of data points.

12. The computer readable medium of claim 9, wherein the instructions when executed by the processor cause the computer system further to:

receive a drill down request on a member of a first analysis dimension from the at least one analysis dimension;

in response to the drill down request;

map the selected measure to a column axis specification of a second query;

map a selected member from a second analysis dimension from the at least one analysis dimension to a row axis specification of the second query;

map the member of the first analysis dimension to a slice specification of the second query;

map the at least one fixed dimension to the slice specification of the second query;

map a data source descriptor to a cube specification of the second query; and

generate the second query according to the mappings.

13. The computer readable medium of claim 9, wherein the instructions when executed by the processor cause the computer system further to:

receive a drill up request on a member of a first analysis dimension from the at least one analysis dimension;

in response to the drill up request;

map the selected measure to a column axis specification of a third query;

map a member from the second analysis dimension to a row axis specification of the third query;

map a parent of the member of the first analysis dimension to a slice specification of the third query;

map the at least one fixed dimension to the slice specification of the third query;

map a data source descriptor to a cube specification of the third query; and

generate the third query according to the mappings.