Patent ID: 8095499
Filing Date: 2012-01-10
Classification: G06F

Abstract:
1. A computer implemented method for consolidating OLAP (Online Analytical Processing) queries, comprising: displaying a structured report within spreadsheet on client application on a client computing device, wherein the structured report is connected to at least one data source and comprises a layout and regions that comprises a row axis, a column axis, a page filter axis and a data grid including cells, wherein the row and column axes define a structure of the report and the data grid is formed by the cells where the axes intersect, wherein each axis more comprise one or more segment that contain one or more members from a dimension; displaying selectable page filters with the display of the structured report that restricts the data that is displayed within one or more cell of the data grid of the structured report without affecting row and column headers of the structured report; wherein the client application is a spreadsheet application that interacts with a query consolidator plug-in of the client application that is located on the client computing device, and functionality of the query consolidator plug-in is included within the client application, and the query consolidator plug-in is configured to perform the following: wherein the second query is configured to query the OLAP cube for data; wherein the first MDX query and second MDX query are generated directly from the examination of the structured report;