How to clear BW/(SAP AS) caches

Technique/SAP BW2011. 1. 21. 09:24

How to clear BW/(SAP AS) caches

How to clear BW/(SAP AS) caches
Martin Maruskin
Business Card
Company: self employed
Posted on Jan. 20, 2011 12:00 PM in Application Server, Business Intelligence (BI), SAP NetWeaver Platform

URL: http://sapport.blogspot.com/2011/01/how-to-clear-bwsap-as-caches.html

There are several places across BW tools from where clearing of different types of cache can be done.

BEx Web Application Designer metadata cache: stores metadata information about objects related to web templates. You can also delete the cache in which metadata information belonging to current opened template within the session to BW backend. To delete this cache choose in BW Web Application Designer: Menu Tools -> Setting -> Delete cache -> Delete cache. Documentation for NW2004 can be found here. This is not valid for BW based on version 7.x.

OLAP Cache: so called Query cache is type of cache is used to buffer BW queries data sets to be available for next query run. In this case OLAP processor first checks cache and do not need to read the data out of BW infoproviders. To clear OLAP cache run TA RSRT -> Cache monitor -> Delete or you can go via TA RSRCACHE. Online docu here. If you want to do it from your custom ABAP program you may use function module: RSR_CACHE_CLEAR_ALL_CACHES.

HTTP server cache: this is related to HTTP server build in SAP AS server. You can clear it via TA SMICM -> Goto -> HTTP server cache -> Invalidate cache -> Global in system. Online docu here.

OLAP Cache: so called Query cache is type of cache is used to buffer BW queries data sets to be available for next query run. In this case OLAP processor first checks cache and do not need to read the data out of BW infoproviders. To clear OLAP cache run TA RSRT -> Cache monitor -> Delete or you can go via TA RSRCACHE. Online docu here. If you want to do it from your custom ABAP program you may use function module: RSR_CACHE_CLEAR_ALL_CACHES.

Martin Maruskin SAP NetWeaver BW certified consultant

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23115%3Futm_source%3Dtwitterfeed%26utm_medium%3Dtwitter%26utm_campaign%3DFeed%253A+SAPNetworkWeblogs+%2528SAP+Network+Weblogs%2529

저작자표시 비영리 동일조건

'Technique > SAP BW' 카테고리의 다른 글

How to find the BW 7.0/7.01 Planning URL. (0)	2011.02.07
BW on Oracle: a performance hitch I see more and more often.... (0)	2011.01.21
Performance Improvements for DataStore Objects: In SAP BW 7.30 (0)	2011.01.19
BW 7.30: Graphical Data Flow Modeling (0)	2010.12.14
Design Consideration for 7.30 InfoProviders - Webinar Presentation (0)	2010.12.14

Posted by AgnesKim

아주가끔은제정신