Question:
Hi there.
In transaction RSRT I am looking at the technical information of a query that we built. Under 'Cache-Relevant Data' it says that the query cannot use the cache. Why is this?
Under query properties, the cache mode is set to 1 (main memory cache without swapping).
I would like to understand how this works as we have a business content query (BW stats) that has the same properties, yet under the technical information the query can use cache!
Any help would be much appreciated.
Answer:
Every time I ask a question on this forum (after scratching my head for an hour) I find out the answer immediately...
The reason is that the particular query has virtual key figs / chars...
If anyone has any idea if there is a work-around for this then let me know!