System and method for network user interface OLAP report formatting
First Claim
1. A system for presenting reports processed by an on-line analytical processing (OLAP) system over a network, the system comprising:
- at least one physical processing device that executes one or more computer program modules that;
receive, from a user system through a web browser, a request for a workbook comprising a plurality of reports and a selection of one or more specified templates or filter combinations to format one or more of the plurality of reports;
return control of the web browser to enable a user to use the web browser to perform one or more other tasks while the workbook request is being processed, wherein the one or more other tasks includes requesting an additional workbook;
receive the workbook comprising the plurality of reports processed by the OLAP system in response to the workbook request;
format one or more of the plurality of reports in the workbook in accordance with the selected one or more specified template or filter combinations received from the user system through the web browser in communication with the OLAP system over the network;
build an interactive spreadsheet application for presenting the workbook at the web browser of the user system, wherein the interactive spreadsheet application configures an arrangement of the plurality of formatted reports in the workbook; and
transmit the workbook including the plurality of formatted reports within a page over the network to the web browser of the user system through which the request was received, wherein the transmitted workbook is presented at the user system using the interactive spreadsheet application displayed within the web browser.
2 Assignments
0 Petitions
Accused Products
Abstract
A network-based system for enabling users connected over the network to an OLAP system to select formatting options for reports requested for processing by the OLAP system. The system enables a user to select the format for each report in a workbook or for a stand-alone report. The format specified may be multiple levels of format that are applied in a hierarchical manner including global formats that apply to all reports in a workbook, report formats which apply to specific reports in the workbooks, attribute/element/metric formats which apply to specific attributes, elements, and metrics of a report, and value formats which apply to specific values within an element of a report. The formats specified may also comprise merged report formats, combined grid and graphs within a report and an autoformat that enables each recipient of the report to specify the format in which that recipient views the report when the report is received.
-
Citations
28 Claims
-
1. A system for presenting reports processed by an on-line analytical processing (OLAP) system over a network, the system comprising:
at least one physical processing device that executes one or more computer program modules that; receive, from a user system through a web browser, a request for a workbook comprising a plurality of reports and a selection of one or more specified templates or filter combinations to format one or more of the plurality of reports; return control of the web browser to enable a user to use the web browser to perform one or more other tasks while the workbook request is being processed, wherein the one or more other tasks includes requesting an additional workbook; receive the workbook comprising the plurality of reports processed by the OLAP system in response to the workbook request; format one or more of the plurality of reports in the workbook in accordance with the selected one or more specified template or filter combinations received from the user system through the web browser in communication with the OLAP system over the network; build an interactive spreadsheet application for presenting the workbook at the web browser of the user system, wherein the interactive spreadsheet application configures an arrangement of the plurality of formatted reports in the workbook; and transmit the workbook including the plurality of formatted reports within a page over the network to the web browser of the user system through which the request was received, wherein the transmitted workbook is presented at the user system using the interactive spreadsheet application displayed within the web browser. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
10. A computer-implemented method of presenting reports processed by an on-line analytical processing (OLAP) system over a network, the method being implemented by a computer that includes a physical processor, the method comprising:
-
receiving, from a user system through a web browser, a request for a workbook comprising a plurality of reports and a selection of one or more specified templates or filter combinations to format one or more of the plurality of reports; returning control of the web browser to enable a user to use the web browser to perform one or more other tasks while the workbook request is being processed, wherein the one or more other tasks includes requesting an additional workbook; receiving the workbook comprising the plurality of reports processed by the OLAP system in response to the workbook request; formatting one or more of the plurality of reports in the workbook in accordance with the selected one or more specified template or filter combinations received from the user system through the web browser in communication with the OLAP system over the network; building an interactive spreadsheet application for presenting the workbook at the web browser of the user system, wherein the interactive spreadsheet application configures an arrangement of the plurality of formatted reports in the workbook; and transmitting the workbook including the plurality of formatted reports within a page over the network to the web browser of the user system through which the request was received, wherein the transmitted workbook is presented at the user system using the interactive spreadsheet application displayed within the web browser. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. An electronic device comprising a non-transitory computer usable storage medium having computer-executable code embodied therein for presenting reports processed by an on-line analytical processing (OLAP) over a network, wherein executing the computer-executable code on a physical processor coupled to the electronic device causes the electronic device to:
-
receive, from a user system through a web browser, a request for a workbook comprising a plurality of reports and a selection of one or more specified templates or filter combinations to format one or more of the plurality of reports; return control of the web browser to enable a user to use the web browser to perform one or more other tasks while the workbook request is being processed, wherein the one or more other tasks includes requesting an additional workbook; receive the workbook comprising the plurality of reports processed by the OLAP system in response to the request for the workbook; format one or more of the plurality of reports in the workbook in accordance with the selected one or more specified template or filter combinations received from the user system through the web browser in communication with the OLAP system over the network; build an interactive spreadsheet application for presenting the workbook at the web browser of the user system, wherein the interactive spreadsheet application configures an arrangement of the plurality of formatted reports in the workbook; and transmit the workbook including the plurality of formatted reports within a page over the network to the web browser of the user system through which the request was received, wherein the transmitted workbook is presented at the user system using the interactive spreadsheet application displayed within the web browser. - View Dependent Claims (20, 21, 22, 23, 24, 25, 26, 27)
-
-
28. A non-transitory computer usable storage medium having computer readable program code embodied therein for presenting reports processed by an on-line analytical processing (OLAP) over a network, wherein the computer readable program code executes on one or more physical computing devices, and wherein executing the computer readable program code on the one or more physical computing devices causes the one or more physical computing devices to:
-
receive, from a user system through a web browser, a request for a workbook comprising a plurality of reports and a selection of one or more specified templates or filter combinations to format one or more of the plurality of reports; return control of the web browser to enable a user to use the web browser to perform one or more other tasks while the workbook request is being processed, wherein the one or more other tasks includes requesting an additional workbook; receive the workbook comprising the plurality of reports processed by the OLAP system in response to the request for the workbook; format one or more of the plurality of reports in the workbook in accordance with the selected one or more template or filter combinations received from the user system through the web browser in communication with the OLAP system over the network, wherein the one or more template or filter combinations specify a plurality of format levels used to format the plurality of reports in the workbook in a hierarchical order; build an interactive spreadsheet application for presenting the workbook at the web browser of the user system, wherein the interactive spreadsheet application configures an arrangement of the plurality of formatted reports in the workbook; and transmit the workbook including the plurality of formatted reports within a page over the network to the web browser of the user system through which the request was received, wherein the transmitted workbook is presented at the user system using the interactive spreadsheet application displayed within the web browser.
-
Specification