OLAP Cache Monitor

Purpose

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.

Integration

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).
Note
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).

Features

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

Note

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.

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
Refresh
Delete	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.