Delete Query Buffer In OLAP

How to delete the Query Buffer in OLAP?

Have been working with the query, after some time there has some changes in cube data. However when I execute the query, it still shows the previous values only.  Would like to delete the existing buffer in OLAP from that query.

Suggestion:

This is not recommended as the system itself will takes care of new records and you do not need to disturb the cache.

Check whether you have any aggregates for the cube, if so perform roll up and check the report output.

Explanation:

Cached results have a timestamp, which is compared with the timestamp of the last data load and meta data change.

If new data is loaded before a cached query is executed again, the OLAP engine states that the cached entry is out-of-date. It removes the old entry, loads the current query result from the InfoProviders and writes back this new OLAP Cache entry. 

The OLAP Cache entry is invalidated in the following cases:

- Transaction Data Load to the underlying InfoProvider(s).

- Deletion of Transaction Data from the underlying InfoProvider(s).

- Master Data Load (and hierarchies) and subsequent change run of InfoObjects contained in the query definition.

- Currency conversion rate change

This invalidation is also done for meta data changes, i.e. changes to the query structure, and query generation.

Note that changes to key dates for time-dependent master data does not result in invalidation, but in an additional cache entry. 

In addition, the OLAP Cache can be invalidated and deleted completely via the OLAP Cache monitor (transaction RSRT - Cache Monitor or transaction RSRCACHE). 

One query entry in the OLAP Cache can be invalidated by simply re-generating the query.

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP BW Books
SAP Business Warehouse Certification, Interview Questions and Configuration Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.