After you build your OLAP query and apply filters, computations, sorts, and any other adjustments to further refine your request, you need to process it. Processing your query may take a few moments if your query is complex, or if the data in linked report sections needs to be refreshed.
To process an OLAP query, select Tools, then Process Query , and then Option.
Since a document can contain multiple queries, the Process drop-down list has three processing options:
Process Current—Processes the current object. In some cases more than one query may be processed, for example, if a report references results sets from multiple queries. Process Current is the default selection when using the toolbar button.
Process Custom—Opens the Process Custom dialog box so that you can indicate which queries to process by selecting a query’s check box.
Interactive Reporting sends the query to the database and retrieve the data to the OLAPQuery section. While the data is being retrieved, the Status bar displays a dynamic count indicating rate and progress of server data processing and network transfer.