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;
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.
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).