If there are multiple queries in a document, you can determine the order in which they get processed, and select which queries to include or exclude from the processing stream.
This feature is particularly useful when you need to use “fresh” data during a local join operation, or to ensure that your local results are populated with current data from a source query not affected by several earlier tables without duplicating the processing of some queries.
Query Processing Order is available for the Query section, OLAPQuery section and any imported data files sections that can be processed in an Interactive Reporting document when you use the “Process All” feature.
Query processing order settings are saved with the document. For a temporary processing order, do not save the document or set the processing order to what is normal for the given document. |
To specify a query processing order:
Select Tools, then Process Query, and then Processing Order.
The Query Processing Order dialog box is displayed.
The first time the Query Processing dialog box is displayed after the new document is created, all query sections belonging to the document are displayed in the order which they are displayed in the Section Catalog (top down). Query sections added after the sections have been arranged, are displayed at the end of the list in the order in which they were added when the dialog box is reopened.
Select a query section and move it up or down in the processing order using the arrow keys to the right.
Double click a query section to remove it from the processing order or add it back and click OK.
Only queries marked with an asterisk (*) are processed during “Process All”.