Show TOC

Setting the Optimization ModeLocate this document in the navigation structure

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.


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.


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.

    For more information, see SAP Note 1137994 Information published on SAP site.