Skip to Content

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 04 at 12:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded