Query read / cache modes are set in BW

[Former Member]

Hi Experts,

What is query read / cache modes are set in BW in order to improve the query performance?

Thanks

Rohan

[Former Member]

REad mode and Cache mode sets how the query will read and caches the result set in application server's memory.

Go to RSRT and give your query name and on top you will see a push button "properties:. Click that and you will see.

Ravi Thothadri

[Former Member]

The read mode defines if a query reads only the necessary data for the first navigation step (and reads the database for every additional navigation step) or if it reads everything in one go (and does not access the database for any additional navigation steps). It can also be set up if hierarchies are read in one go.

The read mode can be defined generally, for InfoCubes and for single queries.

Thanks & regards,

vsn

[Former Member]

Hi

The read mode determines how the OLAP processor gets data during navigation. You can set the mode in Customizing for an InfoProvider and in the Query Monitor for a query.

http://help.sap.com/saphelp_nw04/helpdata/en/57/b10022e849774f9961aa179e8763b6/content.htm

Assign points if it helps...

Regards,

ARK