Skip to Content
author's profile photo Former Member
Former Member

Priming cache by reporting agent problem

Hello All,

I have few questions regarding article on bwexpertonline for priming the cache.

The article is really great and big help....but i am not getting out put the way it should be.

1) I created a query - which doesnt have any variable/selection screen.

(question here is will it work for those kind of queries which dont have any selection screen/ variant ? ) --> client wants to prime the cache for few queries which dont have variable screen.

2) created web template and which refers the same query and save it in favourite.

3) went to RSA1--> Reporting Agent --> web template --> new setting

gave technical name, in parameter tab i selected two options "data" and "HTML for browser" by selecting the checkbox.

4) i dont have any selection screen so couldnt create any variants

5) mark the check box "fill olap cache if possible"

6) Save it and activated it

7) created scheduling package and drag and drop the reporting agent (which is on the left sideunder the webtemplate)

8) schedule it

9) sm37--> released the job and ran it.

10) job finished successfully

now my question is i dont see any entries for that perticular query in RSRCACHE (TCODE). i tired to run query on web, rsrt but still i dont see any entries in cache.

can you pleasse tell me where i m making mistakes ?? also, if i want to prime cache for lets say 6 queries do i have to create web template for each...and repeat the whole process for each ? how do i do that ? And will need to attach it in process chain so it can be run on daily basis.

Any guidance will be appreciated. I will come back and give points for help.

Thank You in advance...

KSMITH

Message was edited by: Keral Smith

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2006 at 08:56 PM

    <i>now my question is i dont see any entries for that perticular query in RSRCACHE (TCODE). i tired to run query on web, rsrt but still i dont see any entries in cache.</i>

    - we'll assume that you don't have the query marked to NOT cache. Where are you caching the result - Main Memory, Appl Server (Flat, Cluster, BLOB) Cross Appl Server (Flat, Cluster, BLOB). Each has separte cache area. DO you have multiple Appl Servers? If you are not using Cross Appl server cache options, you need to look on the Appl Server that the Rpt Agent job ran on.

    <i>can you pleasse tell me where i m making mistakes ?? also, if i want to prime cache for lets say 6 queries do i have to create web template for each...and repeat the whole process for each ? how do i do that ? And will need to attach it in process chain so it can be run on daily basis.</i>

    You could also use Information Broadcasting to run the query. Rpeorting Agent can also be used to schedule the job to run daily without use of Process Chains.

    If the users will drill on Free Chars in the report, then you might want to Change the Read Mode on the query to the navigate and hierachy option (called something like that) so that you cahe the entire possible result set.

    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.