BW7.31: Cache parameter setting BEx query

[Former Member]

Hi experts

We checked our cache setting via RSRCACHE after BW upgrade to 7.31.

Cache Parameter:

Main Memory:

Query Aggregate (BLOB)

RSRT, table RSRREPDIR:

Questions:

As I understood help.sap.com cache mode 5 (BLOB) is the recommended and preferred mode in BW 7.3.

This means that I can ignore the red "alerts" of screen 2, main memory, as the cache automatically is stored in a DB cluster table. Am I right?

Screen 4: Must I change the setting of my queries in RSRT to cache mode 5?

Screen 3: As I understand the new cache mode 5, only the "Query Aggregate" button in RSRCACHE seems to be relevant to monitor frequently? Is this correct?

Thanks

[RamanKorrapati · Accepted solution]

Hi,

1. you can  use cache mode 5, but need to make them green which are red.

Screen 4 : RSRT ---> Cache mode 5, if you report was frequently used.

Screen3: Just click on it and see, it will display all info.

Thanks

[Former Member · Accepted solution]

Hi

I found these notes which answer all my questions, thanks for your help.

1026944 - New cache mode with no directory for BI 7.0

Furthermore this notes includes some more technical details:

1836616 - Shared memory overflow when writing the cache - BRAIN 895

Last, but not least an older version of "How To...Performance Tuning with the OLAP Cache".

A more current version including aspects with BOBJ integration: TechEd 2010 Performance Tuning

The best document on using OLAP cache for performance tuning I found: Configuration and Utilization of the OLAP Cache to Improve the Query Response Time

[Former Member]

Hi Thomas,

I am giving some points here, those are my assuming only. Please have a look on it.

I hope it will not impact but make sure any other query/Info provider should not have Cache Mode Property as: Main memory with or without swapping option.

If we clear the main memory we may have more space in bw--If I am wrong please correct me.

Reply for Screen 4: Definitely we should change the setting to Cache mode 5 as its getting data from that place, so it should be done.

Reply for screen 3:Yes your absolutely right, For Cache modes 3, 4 and 5, this can be checked from the context menu and by clicking Detail button.

Please correct me if I am wrong in any case.

Thanks,

Phani