Bex query not fetching from OLAP cache mode - D

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.