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.
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