|
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 Books
SAP BW Tips
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|