Show TOC

Using the OLAP Cache Despite Virtual Characteristics or Key FiguresLocate this document in the navigation structure

Context

Using the OLAP cache serves to improve performance when executing queries. As the calculation of virtual characteristics or key figures depends on variable values however, repeated execution of queries with virtual characteristics or key figures can often produce differing results.

Note

An example of this is calculating a person's age on the basis of their birth of data and today's date.

If virtual characteristics or key figures are used in the query, usage of the cache is therefore normally deactivated.

If the virtual characteristics or key figures that you are using display the same result for every calculation, you can activate usage of the cache. This means that the InfoObjects are filled with user-specific data using a customer exit (SAP enhancement RSR00002 or BAdI RSR_OLAP_BADI), are written to the cache and from then on are read from the cache.

Caution

If the data is changed by the customer exit, note that this does not result in invalidation of the cache. If the data from the customer exit depends both on the inbound data and for example also on the user, on time or on other tables, the cached data can deviate from the data that would be determined at that moment.

The Using Cache Despite Virtual Characteristics/Key Figures option should therefore only be activated in exceptional cases and after thorough analysis of SAP enhancement RSR00002 or Business Add-In RSR_OLAP_BADI.

Tip

An example of a special case where the Using Cache Despite Virtual Characteristics/Key Figures option could be useful is when using a variable for a virtual characteristic with which the end user in reporting can select constants as the basis for currency translation types.

Procedure

Only select the Using Cache Despite Virtual Characteristics/Key Figures option when really necessary and after thorough analysis.