Skip to Content
author's profile photo Former Member
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.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on 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

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



    SAP NetWeaver RIG, US BI

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2004 at 09:28 AM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.