Query Properties 
Use
On the Query Properties dialog box for the query monitor you can make settings for a BI query with regard to the read mode, the cache mode, the selection of structure elements, the optimization mode and the calculation accuracy. You can switch off the default Parallel Processing for queries on a MultiProvider. For queries with virtual characteristics or key figures you are able to activate the use of the cache, which is deactivated by default. If you activate the display of the generation log you are able to display a log in which you can see the reasons why the query in question was generated again. You do this afterwards using the generation log pushbutton.
Integration
Read Mode and Cache Mode
In Customizing you can specify the standard settings for an InfoProvider for the read mode and the cache mode (with the persistence mode, where necessary). These need to be valid for those queries that will be created for the corresponding InfoProvider. Furthermore, for the InfoProvider for which data changes do not occur under the control of the BI system (for example, VirtualProviders and transactional DataStore objects), you can specify the cache validity, meaning the data retention period in the cache.
For more information, see the Implementation Guide (IMG) for SAP NetWeaver ® Business Intelligence ® Reporting-Relevant Settings ® General Reporting Settings in the Business Explorer ® Properties for InfoProviders.
In the Query Monitor you can change the standard settings for the read mode and the cache mode for existing queries. You can determine the cache validity exclusively for the InfoProvider in Customizing.
Using the selection of structure elements
The Using the Selection of Structure Elements option can be selected for any query but is only really useful in a couple of cases.
In queries, selections are frequently defined on one or more characteristics in the columns, or more precisely in the structure elements. One or more of these structure elements are often filtered in the BEx Analyzer or in Web applications. If you do not select the Using a Selection of Structure Elements option, these dynamic (structure element) selections are not transferred to the database. Normally the data for the entire structure or for both structures is then read from the database.
Accuracy
You can specify the accuracy with which a key figure needs to be calculated in the InfoObject maintenance.
You can only specify the accuracy with which all query key figures need to be calculated in the Query Monitor (and not in the BEx Query Designer in the BI front end). You can use this to “override” the settings made in InfoObject maintenance for individual key figures, where necessary.
Parallel Processing
A query on a
MultiProvider is deconstructed internally into sub-queries. These are
processed in parallel by default. In most cases parallel processing has
benefits in terms of performance. However, in some cases sequential processing
can be more advantageous for query performance (see 
Parallel Processing of
Sub-Queries vs. Sequential Processing).
You are able to switch parallel processing for a MultiProvider off in the RSADMIN table.
You can switch off parallel processing for a query on a MultiProvider in the Query Monitor.
Optimization mode
If you do not make
any other settings the OLAP processor determines the optimal initial size of
the table SP, that is the memory structure in which data is held and processed
in the OLAP processor (see Cache Structure).
This is done after the first execution and again after a period of 31 days
since the last optimization. It automatically generates a report afterwards.
In the Query Properties dialog box in the Query Monitor you can implement, modify of deactivate this function. Choose one of the following options:
· Query Is Optimized after Generation (0)
· Query Optimization with Individual Periods in Days (1) Here you can determine the optimization period yourself.
· Query Optimization Inactive (9)
Prerequisites
You have created the query you want in the BEx Query Designer. The settings specified for the basic InfoProvider in Customizing, or those that were specified earlier in the Query Monitor, apply to the query (see above in the Integration section)
Features
· Using the selection of structure elements
· Generation log
· Do Not Use Parallel Processing
· Using the Cache Despite Virtual Characteristics/ Key Figures
· Optimization mode