Show TOC

Delta CachingLocate this document in the navigation structure

You can use the Update Cache Objects in Delta Process property to specify that individual data in a query is added to the cache.


With the delta cache procedure, you do not need to read all data for the query from the database when the data basis changes. Whether the data is read directly from the database or from the cache does not have any impact on the query results.

The delta cache procedure is suitable for DataStore objects (advanced) with the modeling property All Characteristics are Key, Reporting on Union of Inbound and Active Table and InfoCubes for which the request ID makes it possible to tell which entries will be 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 have been compressed