Skip to Content
author's profile photo Former Member
Former Member

BW7.31: Cache parameter setting BEx query

Hi experts

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

Cache Parameter:

Main Memory:

Query Aggregate (BLOB)



As I understood 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?


Capture1.JPG (27.3 kB)
Capture2.JPG (26.8 kB)
Capture4.JPG (24.0 kB)
Capture3.JPG (68.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 09, 2014 at 02:51 PM


    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.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 03:56 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.