Show TOC

 OLAP Cache MonitorLocate this document in the navigation structure


The OLAP Processor accesses two types of cache, the local cache and the database cache.

The local OLAP cache stores the results calculated by the OLAP Processor in the role area for each session. This is based on a single query instance at runtime.

Unlike the local cache, the database cache is cross-transactional. This makes it possible for various query instances to access the data stored here. This data is optimized for the OLAP Processor. This speeds up execution of the query due to faster access and the fact that the data has already been formatted.

At runtime, all drilldown states of the query - from a given calculation level - are cached locally to start with and then stored in the database cache if required. The entries in the database cache are generated from the local runtime (cache) objects.

The Cache Monitor screen provides you with information about the local cache, the parameters of the database cache, the amount of memory used by the query runtime objects and the current underlying cache structure.


To call the OLAP Cache Monitor (transaction RSRCACHE) from the SAP Easy Access screen, choose Business Explorer →   BEx Monitor →   OLAP: Cache Monitor. From the Query Monitor screen, you can call the OLAP Cache Monitor by pressing  Cache Monitor.

The cache parameters are set in Customizing during implementation. The same settings can also be made in the OLAP Cache Monitor (see Cache Parameters).

  • You can change the cache mode for a query in the Query Monitor screen (see Query Properties).

    You can access an overview of the cache-relevant data for a query (important time stamps for example) from the Query Monitor screen by pressing  Technical Info (see Technical Information).


Cache Status

This shows the cache parameters. The display is based on the settings made in Customizing. Example:

  Cache Status

Cache Active



Database Cache Limit



If you want to choose any of these settings, choose  Cache Parameter.More information: Cache Parameters.

Database Cache

You can view the relevant data in the system:

Pushbutton Display

 Technical Information

Displays cache-related technical data for the query runtime objects and the cache size and number of entries in the cache

 Buffer Objects Hierarchical Display or  Buffer Objects List Display

Displays the buffer objects

In the default setting, the system displays buffer objects in a hierarchically structured query directory.More information: Cache Structure.

Toolbar Functions

The following general functions are available in the toolbar:

Function Information




Deletes the cached data in accordance with the cache mode selected, deleting the buffer objects that you have chosen to display. If no selection has been made, the system does not delete any data. This function is useful when testing.

 Cache Parameter

See Cache Parameters.