Reporting Agent Cache Deletion

[Former Member]

Has anyone any experience in deleting caches of data that were created using the Reporting Agent functionality.

We really need to:

1. understand how to delete the 'DATA' cache for web templates (as opposed to the 'HTML' caches); and

2. understand how to automate the deletion process (both HTML and DATA caches)?

Any information on how the Reporting Agent stores the cached data will also be greatly appreciated.

Andrew.

[Former Member]

Marc,

Thanks for your answer, but I am not talking about the 'read mode' cache. I refer to the 'Reporting agent' cache.

We have created a Web 'portal' and run a series of Reporting Agent jobs to precalculate the HTML. In some cases we use the 'Data' option to 'warm up' the read mode cache. The problem is that the 'RA Data' is persistent on the system, this means that some of our earlier authorisation tests (which produced 'no authorisation' messages) are held in the system and are called whenever we use DATA_MODE=STATIC_HYBRID and after we have manually deleted the HTML pages.

Practically this is a problem because I have to demonstrate to the client that if the HTML job fails for some reason, then the query runs online, currently it doesn't do this because it finds the 'RA Data' cache.

Regards,

Andrew

[former_member93896]

Hello Andrew,

I do not see the need to delete the cache explicitly. If the cache is full for example because of the Reporting Agent, then the next query execution will automatically purge the oldest data from the cache and make room for the new data. That is the beauty of it

You can find the documentation at

http://help.sap.com/saphelp_nw04/helpdata/en/d5/5a393de3bb752de10000000a114084/frameset.htm

If you need to manually delete entries, use the Cache Monitor in transaction RSRT.

Regards,

Marc

SAP NetWeaver RIG, US BI

PS: A quick way to invalidate the complete cache is to load some exchange rates from R/3.