BW OLAP Cache Mode 5 – “BLOB/Cluster Enhanced” – Is the recommended cache mode

With Support Package 16, a new cache mode with an optimized architecture was delivered for BW 7.0. This mode explicitly addresses the basic problems that were connected with the existing cache modes 1-4 up to now. In particular, these include cache entries that have been lost or were not assigned and the blocks due to enqueue locks that occur under a high load.
The new mode is managed in BW 7.0x as “BLOB/Cluster Enhanced” under number 5, or in higher versions of BW, with the same number as “Query Aggregate”.
Performance is usually noticeably better for mode 5, and is therefore recommended as the standard for most applications.

See related note – Note 1026944 – New cache mode with no directory for BI 7.0

See help on OLAP Cache Monitor –

See help on  BW Cahce Mode –

Configuration and Utilization of the  OLAP Cache to Improve the Query Response Time

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.