MULTIDIMENSIONAL FORECASTING

• US 20090106293A1
• Filed: 10/19/2007
• Published: 04/23/2009
• Est. Priority Date: 10/19/2007
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Joseph, Rajit K., Doraiswamy, Ravi C., Vachharajani, Jigar P.
• Application Number:
  US11/875,610
• Publication Number:
  US 20090106293A1
• Time in Patent Office: Days
• US Class Current: 1/1
• 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

Abstract

An apparatus and method for multidimensional forecasting. In one embodiment of the method a database is accessed to select a set of data objects each of which has a date field that contains a date that falls within a predefined time period. The data contained in a first field of each of the set of data objects is summed thereby generating a first total. The data contained in the first field of each of a first subset of the set of data objects is summed thereby generating a first subset total. A user interface is then displayed on a monitor of a computer system, wherein the user interface, when displayed, comprises graphical representations of the first total and the first subset total.

Claims

1. A method comprising:

accessing a database to select a set of data objects each of which has a date field that contains a date that falls within a predefined time period;

summing data contained in a first field of each of the set of data objects thereby generating a first total;

summing the data contained in the first field of each of a first subset of the set of data objects thereby generating a first subset total;

displaying a user interface on a monitor of a computer system, wherein the user interface, when displayed, comprises graphical representations of the first total and the first subset total.

2. The method of claim 1 further comprising:

summing data contained in a second field of each of the set of data objects thereby generating a second total;

summing the data contained in the second field of each of the first subset of the set of data objects thereby generating a second subset total;

wherein the user interface, when displayed, comprises graphical representations of second total and the second subset total.

3. The method of claim 2 wherein each of the set of data objects comprise a third field, wherein the third field of each of the first subset of data objects comprises data that matches a first predefined value.

4. The method of claim 3 further comprising:

summing the data contained in the first field of each of a second subset of the set of data objects thereby generating a third subset total, wherein the data objects of the first subset are distinct from the data objects in the second subset;

summing the data contained in the second field of each of the second subset of the set of data objects thereby generating a fourth subset total;

wherein the user interface, when displayed, comprises graphical representations of the third subset total and the fourth subset total.

5. The method of claim 4 wherein the third field of each of the second subset of data objects comprises data that matches a second predefined value.

6. The method of claim 5 further comprising:

summing the data contained in the first field of each of a subset of the first subset thereby generating a subset total of the first subset total;

summing the data contained in the second field of each of a subset of the second subset thereby generating a subset total of the second subset total;

wherein the user interface, when displayed, comprises graphical representations of the subset total of the first subset total and the subset total of the second subset total.

7. The method of claim 6 wherein each of the set of data objects comprise a fourth field, wherein the fourth field of each data object of the subset of the first subset of data objects comprises data that matches a third predefined value.

8. The method of claim 7 wherein the data of the first field in each of the set of data objects, represents revenue from a sale or potential sale of one or more products to a customer.

9. The method of claim 8 wherein the data of the second field in each of the set of data objects, represents revenue from a sale or potential sale of one or more products to a customer.

10. The method of claim 5 wherein the first and second predefined values comprise first and second names, respectively, of first and second products, respectively, for sale or sold by a company.

12. The computer readable medium of claim 1 wherein the method further comprises:

summing data contained in a second field of each of the set of data objects thereby generating a second total;

summing the data contained in the second field of each of the first subset of the set of data objects thereby generating a second subset total.

13. The computer readable medium of claim 12 wherein each of the set of data objects comprise a third field, wherein the third field of each of the first subset of data objects comprises data that matches a first predefined value.

14. The computer readable medium of claim 13 wherein the method further comprises:

summing the data contained in the first field of each of a second subset of the set of data objects thereby generating a third subset total, wherein the data objects of the first subset are distinct from the data objects in the second subset;

summing the data contained in the second field of each of the second subset of the set of data objects thereby generating a fourth subset total.

15. The computer readable medium of claim 14 wherein the third field of each of the second subset of data objects comprises data that matches a second predefined value.

16. The computer readable medium of claim 15 wherein the method further comprises:

summing the data contained in the first field of each of a subset of the first subset thereby generating a subset total of the first subset total;

summing the data contained in the second field of each of a subset of the second subset thereby generating a subset total of the second subset total;

wherein the user interface, when displayed, comprises graphical representations of the subset total of the first subset total and the subset total of the second subset total.

17. The computer readable medium of claim 16 wherein each of the set of data objects comprise a fourth field, wherein the fourth field of each data object of the subset of the first subset of data objects comprises data that matches a third predefined value.

18. The computer readable medium of claim 17 wherein the data of the first field in each of the set of data objects, represents revenue from a sale or potential sale of one or more products to a customer.

19. The computer readable medium of claim 18 wherein the data of the second field in each of the set of data objects represents revenue from a sale or potential sale of one or more products to a customer.

20. The computer readable medium of claim 15 wherein the first and second predefined values comprise first and second names, respectively, of first and second products, respectively, for sale or sold by a company.

11. A computer readable medium storing instructions, wherein a method is implemented when the instructions are executed, method comprising:

accessing a database to select a set of data objects each of which has a date field that contains a date that falls within a predefined time period;

summing data contained in a first field of each of the set of data objects thereby generating a first total;

summing the data contained in the first field of each of a first subset of the set of data objects thereby generating a first subset total.

21. An apparatus comprising:

a first circuit for accessing a database to select a set of data objects each of which has a date field that contains a date that falls within a predefined time period;

a second circuit for summing data contained in a first field of each of the set of data objects thereby generating a first total;

a third circuit for summing the data contained in the first field of each of a first subset of the set of data objects thereby generating a first subset total;

a monitor for displaying a user interface on a monitor of a computer system, wherein the user interface, when displayed, comprises graphical representations of the first total and the first subset total.