Skip to Content

3 ways to change your queries to the new cache mode

Although Cache Mode number 5 “BLOB/Cluster Enhanced” was delivered with support package 16, there is still a considerable amount of users that don’t know how to apply change their queries in order to use the new cache mode. Specially changing many queries at the same time can take a lot of tedious effort if you don’t know certain “shortcuts”.

This post presents 3 ways to change your BW queries in order to use the new query cache mode. 

Updating Query Cache Mode – At the Query Level

At this level, you only change the mode of one query at a time. Here are the steps to perform:

1) Run transaction RSRT;
2) Fill in Query and select Properties;
3) Change to cache mode ‘5’;
4) Save the change and regenerate the query;

Level 1

This is the most basic change level for this property. Using this level you only change one query at a time. If you want to change more than one queries at the same time check the other levels of change that can be carried.  

Updating Query Cache Mode – At the infoprovider level 

All queries that uses the referred infoprovider will change the cache mode      automatically. Steps to perform this action:

1) Run RSA1 transaction;
2) Search for the infoprovider you want to change the standard cache mode and display it (double click);
3) Go to menu Environment -> Infoprovider Properties -> Change;
4) Set the new value on ‘Cache Mode’ field and save the changes;



Afterwards you can check the properties of the queries that uses this infoprovider and they’ll be all in the cache mode set in the infoprovider level.

Updating Query Cache Mode – Mass Maintenance 

Setting Query Mass Maintenance for an infoprovider. Steps to perform      this action are:

1) Run RSRT transation;
          2) Menu Environment -> Query Mass Maitenance;
          3) Enter InfoCube and list all Queries;
          4) Select Queries and change accordingly.

level 3

After this change, all queries selected in the first screen will be changed. This is the best procedure to change the cache mode, as you can save lots of time by selecting the amount of queries desired.

“Wait! There’s no cache mode 5 here!”

If you’re already over support package 16 but you can not see the mode 5 in the query properties you might need to activate it on RSADMIN table. In order to do that, run report SAP_RSADMIN_MAINTAIN (from SE38) and choose “INSERT” to add the values:

               OBJECT:    RSR_CACHE_ACTIVATE_NEW               VALUE:     X

If that value already exists make sure the value ‘X’ is assigned to the object RSR_CACHE_ACTIVATE_NEW (use the “UPDATE” command instead).

You must be Logged on to comment or reply to a post.
  • The issue is not only application of this cache more, but as well understanding of it. Could you please put some light on when and why this cache mode should be used? Thank you. -Vitaliy
  • Hi Lucas, it’s really very clear all the explanation. I’m needing to perform some cache optimization at 7.3 version, but after following the steps to add the 5 “BLOB/Cluster Enhanced” cache mode, it’s not appears like an option of cache mode at RSDIPROP or RSRT properties.

    Do you know if exists another customization to obtain that same cache mode result?


    • Hello Mariano,

      On BW 7.3 this is the actual standard cache mode. The name might have changed though. Just out of cuiriosity, what are the modes you see from RSRT query properties?

      • Lucas,

        After adding the RSR_CACHE_ACTIVATE_NEW and x values to the RSADMIN table, the available options at the RSDIPROP cache mode menu are:


        0 Cache is inactive

        1 Main Memory  Cache without swapping

        5 Query-Aggregate Cache

        Also, appears the same options  at the RSRT properties adding a new one called “4” without any additional text.


        • Hi Mariano,
          That 5 right there is the one we need as far as I know. Anyway, if you’re having trouble with your cache setup I recommend you open a new thread on the forum or an SAP OSS message.