Bex query not fetching from OLAP cache mode - D

[jack_sd]

Hello All,

Recently we have done a selective deletion of one record from a cube having aggregates. This cube is having indexes and data has been compressed as well.

But after that the query is not fetching data with Cache mode D (data base). we have changed the setting in RSRT as Cache mode I (inactive cache) and then its running.

Could you please let me know why this happened and what to be done to get back the query to pick from CACHE.

FYI, as of now the query cashe data is about 55MB.

Thanks.

[kohesco]

Hi,

I guess you want to get rid of the faulty cache and replace it by th correct cache?

if yes, you can remove the faulthy cache by tcode: RSRCACHE -> databasechache -> select your query-cache and delete

you can fill it up by running the query again (cachemode=D) via process chain or via bex broadcaster

[jack_sd]

Hi Koen hesters,

Thanks for the reply. But below are my questions.

1. Why the query got disconnected from Cache mode D (data base) after doing selective deletion from the infocube. What is the exact technical reason behind this.

2. What precautions has to be taken in future to avoid this kind of issue (if we need to do selective deletion again).

We can delete the Cache for that particular query thru RSRCACHE. But to have a permanent solution kindly clarify the about points.

Regards

Dheeraj

[kohesco]

Hi,

https://wiki.scn.sap.com/wiki/display/BI/OLAP+Cache

check out "Cache Invalidation"

the cache object may not be touched

soluction/workaround:

try to create a process chain doing all the neceseary steps -> selective deletion and reload cache

https://blogs.sap.com/2013/08/06/selective-deletion-in-process-chain/