Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Virtual Providers and Cache Validity

As explained in OLAP Cache, by default the OLAP cache cannot be taken by queries defined on virtual Providers. The following simple example shows how a query can use the cache when the so called 'cache validity' is maintained in trasnaction RSDIPROP.

Virtual Cube based on HanaView

A query based on this Provider can only use the cache when the following paramter is set in transaction RSDIPROP:

This means that a cache object has a life time of one hour. When a query is executed it is checked whther the propper cache object is already older than 3600 seconds. If yes, the object is not taken and the query has to retrieve the data from the database. Afterwards it creates a new cache object(which again can only be used for one hour).

Query

In addition to the cache validity defined on the provider level, the query has to have the correct cache setting:

 

One possibilty to check whether the query really has used the cache, is to take a look at the runtime statistics in transaction RSRT:

In case the cache was used, there shouldn't be a record regarding the DataManager(which handles the database access):

Transaction RSRCACHE

In transaction RSRCACHE we can find the corresponding cache object:

  • No labels