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.
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.
For more information, see SAP Note 1137994 .