Integrated predictive analysis

• US 10,380,134 B2
• Filed: 12/19/2016
• Issued: 08/13/2019
• Est. Priority Date: 12/19/2016
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Su, Teresa, Rittinger, Jan, Hajizadeh, Amir
• Primary Examiner(s): Le, Hung D
• Application Number:
  US15/382,920
• Publication Number:
  US 20180173707A1
• Time in Patent Office: 967 Days
• Field of Search: None
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A system includes determination of a query context comprising a measure and one or more dimension values of a data source, generation of a query of the data source for the measure over time and aggregated over the one or more dimension values, reception of a result set of the query, providing of the result set to a predictive analysis engine, and reception of forecast data based on the result set, the forecast data comprising forecast values of the measure over time, aggregated over the one or more dimension values.

Claims

1. A system comprising:

a user device to;

receive, from a user, a selection of a value of a measure; and

a server device to;

receive the selection of the value of the measure from the user device;

determine a query context based on the selection, the query context comprising the measure and one or more dimension values of a data source associated with the measure value;

generate a query of the data source for the measure over time and aggregated over the one or more dimension values;

receive a result set of the query;

provide the result set to a predictive analysis engine;

receive forecast data based on the result set, the forecast data comprising forecast values of the measure over time, aggregated over the one or more dimension values;

receive an instruction from the user device to incorporate the forecast data into the data source; and

determine two or more disaggregated forecast measure values for each forecast measure value, each of the two or more disaggregated forecast measure values being associated with a combination of child dimension values of the one or more dimension values.

2. The system according to claim 1, wherein selection of the value of the measure comprises selection of a table cell including the value, wherein the measure and the one or more dimension values are associated with a row or a column of the table cell.

3. The system according to claim 1, wherein the query context comprises a filter on one of the one or more of the dimension values, and wherein the query comprises the filter.

4. The system according to claim 1, wherein generation of the query comprises generation of a query including a filter for each of the one or more dimension values.

5. The system according to claim 4, and wherein the query context comprises a query filter, and wherein generation of the query comprises generation of a query including the query filter.

6. A system comprising:

a memory storing processor-executable process steps; and

a processor to execute the processor-executable process steps to cause the system to;

determine a query context comprising a measure and one or more dimension values of a data source;

generate a query of the data source for the measure over time and aggregated over the one or more dimension values;

receive a result set of the query;

provide the result set to a predictive analysis engine;

receive forecast data based on the result set, the forecast data comprising forecast values of the measure over time, aggregated over the one or more dimension values;

receive an instruction to incorporate the forecast data into the data source; and

determine two or more disaggregated forecast measure values for each forecast measure value, each of the two or more disaggregated forecast measure values being associated with a combination of child dimension values of the one or more dimension values.

7. The system according to claim 6, wherein the query context comprises a filter on one of the one or more of the dimension values, and wherein the query comprises the filter.

8. The system according to claim 6, wherein generation of the query comprises generation of a query including a filter for each of the one or more dimension values.

9. The system according to claim 8, and wherein the query context comprises a query filter, and wherein generation of the query comprises generation of a query including the query filter.

10. The system according to claim 6, wherein determination of the query context comprises reception of a selection of a table cell including a value, and determination of the measure and the one or more dimension values based on the table cell.

11. The system according to claim 10, wherein determination of the measure and the one or more dimension values based on the table cell comprises determination of the row and column associated with the table cell and determination that the measure and the one or more dimension values are associated with the row or the column.

12. A computer-implemented method comprising:

determining a query context comprising a measure and one or more dimension values of a data source;

generating a query of the data source for the measure over time and aggregated over the one or more dimension values;

receiving a result set of the query;

providing the result set to a predictive analysis engine;

receiving forecast data based on the result set, the forecast data comprising forecast values of the measure over time, aggregated over the one or more dimension values;

receiving an instruction to incorporate the forecast data into the data source; and

determining two or more disaggregated forecast measure values for each forecast measure value, each of the two or more disaggregated forecast measure values being associated with a combination of child dimension values of the one or more dimension values.

13. The method according to claim 12, wherein the query context comprises a filter on one of the one or more of the dimension values, and wherein the query comprises the filter.

14. The method according to claim 12, wherein generating the query comprises generating a query including a filter for each of the one or more dimension values.

15. The method according to claim 14, and wherein the query context comprises a query filter, and wherein generating the query comprises generating a query including the query filter.

16. The method according to claim 12, wherein determining the query context comprises receiving a selection of a table cell including a value, and determining the measure and the one or more dimension values based on the table cell.

17. The method according to claim 16, wherein determining the measure and the one or more dimension values based on the table cell comprises determining the row and column associated with the table cell and determining that the measure and the one or more dimension values are associated with the row or the column.