Multidimensional modeling system and related method

• US 20070250295A1
• Filed: 03/30/2006
• Published: 10/25/2007
• Est. Priority Date: 03/30/2006
• Status: Abandoned Application

• Current Assignee: Subx, Inc. (Danaher Corporation)
• Original Assignee: Subx, Inc. (Danaher Corporation)
• Inventors: Murray, Peter, Salisbury, Michael, Houle, Christopher, Cabana, Brian
• Application Number:
  US11/393,361
• Publication Number:
  US 20070250295A1
• Time in Patent Office: Days
• US Class Current: 703/2
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A computer-enabled system and related method to perform multi-dimensional modeling. The system includes a model building function, a data link function, a dependency inspector function and a presentation function. The system unlocks the connectivity between model logic, model structure and outcome presentation. Model cells are given understandable names, and the system allows parsing and reorganization of model information without loss of logic, including formulas associated with cell elements. The data link function enables a user to insert into a matrix of the system external information of an array of data types. The dependency inspector function enables a user to quickly and easily identify relationships among cell elements. This capability reduces the time required to detect modeling errors, to audit the model, and/or understand logical relationships embodied in the model.

Claims

1. A system for modeling one or more outcomes based on input information on a computer system, the system comprising:

a. a model building function, the model building function arranged to generate one or more multi-dimensional matrices containing the input information and calculated information, wherein the calculated information is obtained using one or more of formulas, assumptions, and/or input information, each of the one or more matrices including a plurality of cells of input information and calculated information; and

b. a data link function, the data link function arranged to configure external information into a selectable format for introduction into any of the one or more matrices and selectable calculation of calculated information therefrom.

2. The system as claimed in claim 1 further comprising a dependency inspector function, wherein the dependency inspector function is arranged to determine and make available for review the dependency of a particular cell of any of the one or more matrices on one or more other cells of any of the one or more matrices.

3. The system as claimed in claim 1 wherein the data link function includes a source configuration subfunction to configure the external information into a selectable type, and a destination configuration subfunction to configure any of the one or more matrices into a selectable type for entering the configured external information.

4. The system as claimed in claim 3 wherein the selectable type of the source configuration subfunction is selected from the group consisting of Delimited Text File, JDBC/ODBC Data Source, Two Dimensional Data Matrix, Web Services (SOAP), and XML Data Source.

5. The system as claimed in claim 4 wherein the selectable type of the destination configuration subfunction is selected from the group consisting of a two-dimensional matrix and a multidimensional matrix.

6. The system as claimed in claim 1 comprising an architecture including a logic aspect, a structure aspect and a presentation aspect, wherein the logic aspect, the structure aspect and the presentation aspect can each be manipulated without affecting the other aspects.

7. The system as claimed in claim 1 wherein the model building function includes an arrangement for naming categories of information and items of information using understandable language.

8. The system as claimed in claim 1 further comprising a calculation engine of the model building function arranged to create and apply one or more formulas.

9. The system as claimed in claim 8 wherein the calculation engine includes a USING AS formula syntax.

10. The system as claimed in claim 8 wherein any of the one or more formulas of one of the one or more matrices may perform calculations using information from one or more other matrices.

11. The system as claimed in claim 8 wherein any single one of the one or more formulas may be used to calculate calculated information across a range of the plurality of cells of any of the one or more matrices.

12. The system as claimed in claim 1 wherein the computer system includes a display, the system further comprising a presentation function arranged to display on the display of the computer system the one or more matrices, and further arranged to enable a user to manipulate the appearance of the one or more matrices on the display.

13. The system as claimed in claim 12 wherein categories of information are represented as category tiles of the one or more matrices.

14. The system as claimed in claim 13 wherein the model building function enables manipulation of the positioning of any category tile on any of the one or more matrices within and across matrices without requiring re-introduction of the input information or the calculated information.

15. The system as claimed in claim 12 wherein the model building function includes a filtering function to enable a change in the presentation of the input information and calculated information of any of the one or more matrices without requiring re-introduction of any of the input information or calculated information.

16. A system for modeling one or more outcomes based on input information on a computer system, the system comprising:

a. a model building function, the model building function arranged to generate one or more multi-dimensional matrices containing the input information and calculated information, wherein the calculated information is obtained using one or more of formulas, assumptions, and/or input information, each of the one or more matrices including a plurality of cells of input information and calculated information; and

b. a dependency inspector function, the dependency inspector function arranged to determine and make available for review the dependency of a particular cell of any of the one or more matrices on one or more other cells of the one or more matrices.

17. The system as claimed in claim 16 further comprising a data link function, the data link function arranged to configure external information into a selectable format for introduction into any of the one or more matrices and selectable calculation of calculated information therefrom.

18. The system as claimed in claim 17 wherein the data link function includes a source configuration subfunction to configure the external information into a selectable type, and a destination configuration subfunction to configure any of the one or more matrices into a selectable type for entering the configured external information.

19. The system as claimed in claim 18 wherein the selectable type of the source configuration subfunction is selected from the group consisting of Delimited Text File, JDBC/ODBC Data Source, Two Dimensional Data Matrix, Web Services (SOAP), and XML Data Source.

20. The system as claimed in claim 19 wherein the selectable type of the destination configuration subfunction is selected from the group consisting of a two-dimensional matrix and a multidimensional matrix.

21. The system as claimed in claim 16 comprising an architecture including a logic aspect, a structure aspect and a presentation aspect, wherein the logic aspect, the structure aspect and the presentation aspect can each be manipulated independently without affecting other aspects.

22. The system as claimed in claim 16 wherein the model building function includes an arrangement for naming categories of information and items of information using understandable language.

23. The system as claimed in claim 16 further comprising a calculation engine of the model building function arranged to create and apply one or more formulas.

24. The system as claimed in claim 23 wherein any of the one or more formulas of one of the one or more matrices may perform calculations using information from one or more other matrices.

25. The system as claimed in claim 23 wherein any single one of the one or more formulas may be used to calculate calculated information across a range of the plurality of cells of any of the one or more matrices.

26. The system as claimed in claim 23 wherein the calculation engine includes a USING AS formula syntax.

27. The system as claimed in claim 23 wherein each of the one or more formulas includes a modifiable left side and a modifiable right side.

28. The system as claimed in claim 27 wherein the dependency inspector function is configured to detect one or more cell inputs to a selectable cell of any of the one or more matrices and one or more cell outputs from the selectable cell based on information from the left side and the right side of any formulas including the selectable cell.

29. The system as claimed in claim 16 wherein the computer system includes a display, the system further comprising a presentation function arranged to display on the display of the computer system the one or more matrices, and further arranged to enable a user to manipulate the appearance of the one or more matrices on the display.

30. The system as claimed in claim 29 wherein categories of information are represented as category tiles of the one or more matrices.

31. The system as claimed in claim 30 wherein the model building function enables manipulation of the positioning of any category tile on any of the one or more matrices within and across matrices without requiring re-introduction of the input information or the calculated information.

32. The system as claimed in claim 29 wherein the model building function includes a filtering function to enable a change in the presentation of the input information and calculated information of any of the one or more matrices without requiring re-introduction of any of the input information or calculated information.

33. A system for modeling one or more outcomes based on input information on a computer system including a display, the system comprising:

a model building function, the model building function arranged to generate one or more multi-dimensional matrices containing the input information and calculated information, wherein the calculated information is obtained using one or more of formulas, assumptions, and/or input information, each of the one or more matrices including a plurality of cells of input information and calculated information, and wherein the model building function includes a calculation engine arranged to create and apply one or more formulas, wherein the calculation engine includes a USING AS formula syntax.

34. The system as claimed in claim 33 further comprising a dependency inspector function arranged to determine and make available for review the dependency of a particular cell of any of the one or more matrices on one or more other cells of any of the one or more matrices.

35. The system as claimed in claim 34 further comprising a data link function arranged to configure external information into a selectable format for introduction into any of the one or more matrices and selectable calculation of calculated information therefrom.

36. The system as claimed in claim 33 further comprising a data link function arranged to configure external information into a selectable format for introduction into any of the one or more matrices and selectable calculation of calculated information therefrom.

37. The system as claimed in claim 36 wherein the data link function includes a source configuration subfunction to configure the external information into a selectable type, and a destination configuration subfunction to configure any of the one or more matrices into a selectable type for entering the configured external information.

38. The system as claimed in claim 37 wherein the selectable type of the source configuration subfunction is selected from the group consisting of Delimited Text File, JDBC/ODBC Data Source, Two Dimensional Data Matrix, Web Services (SOAP), and XML Data Source.

39. The system as claimed in claim 38 wherein the selectable type of the destination configuration subfunction is selected from the group consisting of a two-dimensional matrix and a multidimensional matrix.

40. The system as claimed in claim 33 wherein the computer system includes a display, the system further comprising a presentation function arranged to display on the display of the computer system the one or more matrices, and further arranged to enable a user to manipulate the appearance of the one or more matrices on the display.