Setting the Optimization Mode

In the query monitor, you use the Query Properties dialog box to specify how often memory requirements of the OLAP processor are optimized for existing queries.

Context

If you do not make any other settings, the OLAP processor specifies the optimal memory requirements for the data processed in the OLAP processor. This is done after the query is executed for the first time and then again 31 days after the last optimization. A report is generated automatically. You can implement, modify, or deactivate this function in the Query Properties dialog box in query monitor.

Procedure

Choose one of the following options:

Query Will Be Optimized after Generation (0): Default setting
Query Optimization with Individual Periods in Days (1) You can specify the optimization period as required. You can use this setting if the InfoCube data is periodically fully reloaded or rebuilt.
Query Optimization Inactive (9): This setting is usually only used for test and support purposes or in exceptional cases.
Note
For more information, see SAP Note 1137994 .