Generating free form reports within a data array
First Claim
1. A method of generating a free form report within a data array having rows and columns providing a first axis and a second axis, comprising:
- receiving a selection of at least one first dimension member that is of at least one data source and that is for the first axis;
receiving a location within the data array for a first dimension member header for the selected first dimension member;
in response to the selection of the first dimension member, generating a first dimension member formula that is representative of the first dimension member header and that includes a first dimension member identifier that relates to the at least one data source;
receiving a selection of a second dimension member that is of the at least one data source and that is for the second axis;
receiving a location within the data array for a second dimension member header for the selected second dimension member; and
in response to the selection of the second dimension member, generating a second dimension member formula that is representative of the second dimension member header and that includes a second dimension member identifier that relates to the at least one data source;
in response to generating the first dimension member formula and the second dimension member formula, generating a value formula that represents a value to be displayed for an intersection of the row and column where the first and second member dimension headers are located, and the value formula references the first dimension member identifier and the second dimension member identifier for the intersection to which the value formula corresponds.
2 Assignments
0 Petitions
Accused Products
Abstract
Free form reports may be generated within a data array system such as a spreadsheet computer application. A user may select dimension members of a data source, such as an online analytical processing (OLAP) data cube. The user may position the dimension members as headers on the data array where multiple dimensions may be represented in one or both axes. Member formulas are generated that are representative of the headers and include identifiers that point to the dimension member location of the data source. Value formulas are generated within the report grid defined by the location of the headers where the value formulas are representative of the actual data values of the report and include identifiers that point to the data value locations of the dimension member locations within the data source.
75 Citations
20 Claims
-
1. A method of generating a free form report within a data array having rows and columns providing a first axis and a second axis, comprising:
-
receiving a selection of at least one first dimension member that is of at least one data source and that is for the first axis;
receiving a location within the data array for a first dimension member header for the selected first dimension member;
in response to the selection of the first dimension member, generating a first dimension member formula that is representative of the first dimension member header and that includes a first dimension member identifier that relates to the at least one data source;
receiving a selection of a second dimension member that is of the at least one data source and that is for the second axis;
receiving a location within the data array for a second dimension member header for the selected second dimension member; and
in response to the selection of the second dimension member, generating a second dimension member formula that is representative of the second dimension member header and that includes a second dimension member identifier that relates to the at least one data source;
in response to generating the first dimension member formula and the second dimension member formula, generating a value formula that represents a value to be displayed for an intersection of the row and column where the first and second member dimension headers are located, and the value formula references the first dimension member identifier and the second dimension member identifier for the intersection to which the value formula corresponds. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A computer readable medium having computer-executable instructions for generating a free form report within a data array having rows and columns defining first and second axes by performing steps comprising:
-
determining at least one data source where dimension and “
Measure”
information is located;
generating a first set of member formulas representative of each of a set of first dimension member headers that includes a first dimension member identifier that relates to a first dimension member of the at least one data source;
generating a second member formula representative of a second dimension member header that includes a second dimension member identifier that relates to a second dimension member of the at least one data source; and
generating a set of value formulas, each value formula representing a value to be displayed for an intersection of the rows and a columns where the first and second member dimension headers are located, and each value formula referencing the first and second dimension member identifiers for the intersection to which the value formula corresponds. - View Dependent Claims (13, 14, 15, 16, 17, 18)
-
-
19. A computer system for building a free form report in a data array including rows and columns that define first and second axes, comprising:
-
a physical network connection that establishes a logical connection to at least one data source that provides dimensions including “
Measures”
for the free form report;
a user input device;
a display system;
a processor in communication with the physical network connection, the user input device, and the display system, the processor executing instructions that;
provide via the display system available dimension members from the at least one data source;
through the user input device, receive a selection of first dimension members for the first axis and a location within the data array for first dimension member headers for the selected first dimension members;
in response to the selection of the first dimension members, generate a first set of member formulas where each member formula of the first set is representative of one of the first dimension member headers and where each of member formula includes a first dimension member identifier that relates to the at least one data source;
through the user input device, receive a selection of at least one second dimension member for the second axis and a location within the data array for a second dimension member header for the selected second dimension member;
in response to the selection of the second dimension member, generate a second member formula representative of the second dimension member header that includes a second dimension member identifier that relates to the at least one data source;
provide via the display system available “
Measure”
dimension members from the at least one data source;
through the user input device, receive a selection of a “
Measure”
dimension member associated with a “
Measure”
dimension member identifier; and
in response to the selection of the “
Measure”
dimension member, generate a set of value formulas where each value formula is representative of one value to be displayed for each intersection of the rows and columns where the first and second member dimension headers are located and wherein each value formula includes a reference to the first and second dimension member identifiers for the intersection to which the value formula corresponds and a reference to the “
Measure”
dimension member identifier. - View Dependent Claims (20)
-
Specification