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