Activating Delta Caching 

Use

The delta cache process allows you to add specific data for a request to the cache. This means that when the data basis changes, you do not have to read all data for the request from the database. Whether the data is read directly from the database or from the cache does not have any impact on the query results.

InfoCubes are suited to the delta cache process because their request ID can be used to identify which entries have been added.

The following figure illustrates the principle using two new requests for an InfoCube; these requests are additionally read for a query request and are copied to the cache.

In this example, requests 4-5 from the InfoCube are read in addition to requests 1-3, which are stored in the cache.

The cache still has to be rebuilt when:

●        changes are made to metadata, master data, hierarchies, or exchange rates

●        InfoProviders are not suited to the delta cache process

●        InfoProviders were compressed

Procedure

Assuming the InfoProvider is suited to the process, you can activate or deactivate the delta cache process for the selected query by selecting the Update Cache Objects in Delta Cache Processindicator in the query properties dialog box.

The setting specified for the InfoProvider is used by default. 

If the query is based on a MultiProvider, you can optimize the runtime for the query by setting the grouping for the InfoProvider accordingly (see Specifying the Grouping for Delta Caching).