Method for capturing design-time and run-time formulas associated with a cell
First Claim
1. A computer-implemented method, comprising:
- providing a spreadsheet application interface for designing a report including a plurality of cells, each of the cells being disposed at an intersection of a spreadsheet coordinates corresponding with and configured to present information derived from data retrievable from a multidimensional database;
in one or more of the cells of the spreadsheet, receiving a run-time formula specified in syntax understandable by the spreadsheet application that is stored separately from the report, the formula being configured to generate a result in the one or more cells that modifies a result of the report;
associating a tuple with the formula identifying the spreadsheet coordinates of the one or more cells with which the formula is associated, the spreadsheet coordinates being specified in terms of content represented by the row and column addresses;
generating a formula list associated with the report, the formula list including an entry for the tuple and the formula associated with the tuple;
storing the formula list in metadata associated with the report; and
configuring the report to be locally generated in the spreadsheet application, wherein locally generating the report includes;
retrieving the data from the multidimensional database referenced in the report;
determining whether the report includes the spreadsheet coordinates corresponding to the tuple in the formula list;
prioritizing an application of formulas in the formula list when at least two formulas operate on a same value within the report;
applying the formula stored in the formula list to the one or more cells in the report having the spreadsheet coordinates identified by the tuple; and
displaying the report as a spreadsheet in the spreadsheet application including results generated by the application of the formula.
2 Assignments
0 Petitions
Accused Products
Abstract
An interface for designing a report is provided, with elements of the report being disposed at intersections of report positions and configured to present information derived from data in a database. A formula is associated with one or more selected elements in the report to generate a result for the one or more selected elements. A tuple identifying the report positions of the one or more selected elements is associated and stored with the formula in a formula list associated with the report. The report is configured so that, when the report is generated, it is determined whether identifying report positions corresponding to an identified element in the report correspond with the tuple in the formula list. Upon determining the tuple corresponds with the identifying report positions for the identified element, the formula associated with the tuple is applied to generate the result.
27 Citations
20 Claims
-
1. A computer-implemented method, comprising:
-
providing a spreadsheet application interface for designing a report including a plurality of cells, each of the cells being disposed at an intersection of a spreadsheet coordinates corresponding with and configured to present information derived from data retrievable from a multidimensional database; in one or more of the cells of the spreadsheet, receiving a run-time formula specified in syntax understandable by the spreadsheet application that is stored separately from the report, the formula being configured to generate a result in the one or more cells that modifies a result of the report; associating a tuple with the formula identifying the spreadsheet coordinates of the one or more cells with which the formula is associated, the spreadsheet coordinates being specified in terms of content represented by the row and column addresses; generating a formula list associated with the report, the formula list including an entry for the tuple and the formula associated with the tuple; storing the formula list in metadata associated with the report; and configuring the report to be locally generated in the spreadsheet application, wherein locally generating the report includes; retrieving the data from the multidimensional database referenced in the report; determining whether the report includes the spreadsheet coordinates corresponding to the tuple in the formula list; prioritizing an application of formulas in the formula list when at least two formulas operate on a same value within the report; applying the formula stored in the formula list to the one or more cells in the report having the spreadsheet coordinates identified by the tuple; and displaying the report as a spreadsheet in the spreadsheet application including results generated by the application of the formula. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer-readable medium, excluding transmission media, storing instructions executable by a computing system, comprising instructions to:
-
providing a spreadsheet application interface for designing a report including a plurality of cells, each of the cells being disposed at an intersection of a spreadsheet coordinates corresponding with and configured to present information derived from data retrievable from a multidimensional database; in one or more of the cells of the spreadsheet, receiving a run-time formula specified in syntax understandable by the spreadsheet application that is stored separately from the report, the formula being configured to generate a result in the one or more cells that modifies a result of the report; associating a tuple with the formula identifying the spreadsheet coordinates of the one or more cells with which the formula is associated, the spreadsheet coordinates being specified in terms of content represented by the row and column addresses; generating a formula list associated with the report, the formula list including an entry for the tuple and the formula associated with the tuple; storing the formula list in metadata associated with the report; and configuring the report to be locally generated in the spreadsheet application, wherein locally generating the report includes; retrieving the data from the multidimensional database referenced in the report; determining whether the report includes the spreadsheet coordinates corresponding to the tuple in the formula list; prioritizing an application of formulas in the formula list when at least two formulas operate on a same value within the report; applying the formula stored in the formula list to the one or more cells in the report having the spreadsheet coordinates identified by the tuple; and displaying the report as a spreadsheet in the spreadsheet application including results generated by the application of the formula. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A system, comprising:
-
a processor and a computer-readable medium; the processor configured to perform actions, comprising; providing a spreadsheet application interface for designing a report including a plurality of cells, each of the cells being disposed at an intersection of a spreadsheet coordinates corresponding with and configured to present information derived from data retrievable from a multidimensional database; in one or more of the cells of the spreadsheet, receiving a run-time formula specified in syntax understandable by the spreadsheet application that is stored separately from the report, the formula being configured to generate a result in the one or more cells that modifies a result of the report; associating a tuple with the formula identifying the spreadsheet coordinates of the one or more cells with which the formula is associated, the spreadsheet coordinates being specified in terms of content represented by the row and column addresses; generating a formula list associated with the report, the formula list including an entry for the tuple and the formula associated with the tuple; storing the formula list in metadata associated with the report; and configuring the report to be locally generated in the spreadsheet application, wherein locally generating the report includes; retrieving the data from the multidimensional database referenced in the report; determining whether the report includes the spreadsheet coordinates corresponding to the tuple in the formula list; prioritizing an application of formulas in the formula list when at least two formulas operate on a same value within the report; applying the formula stored in the formula list to the one or more cells in the report having the spreadsheet coordinates identified by the tuple; and displaying the report as a spreadsheet in the spreadsheet application including results generated by the application of the formula. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification