Skip to Content
avatar image
Former Member

Reporting Agent Cache Deletion

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 28, 2004 at 11:23 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 29, 2004 at 09:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded