Question:
I am asked by the users to:
Be able to use the cache for reports while they still can filter and use exceptions etc. Can we do that? We have a number of reports that are created over and over by a large user group. It makes sense to create a more generalized report in the cache so everyone accesses it and use filters or whatever constrains to see what they want to.
Any ideas? Can we do the caching at query level for similar results? The data is loaded daily so the cache would only have one day life.
Thanks for your help.
Bill
Answer:
I am asked by the users to:
Be able to use the cache for reports while they still can filter and use exceptions etc. Can we do that? We have a number of reports that are created over and over by a large user group. It makes sense to create a more generalized report in the cache so everyone accesses it and use filters or whatever constrains to see what they want to.
Any ideas? Can we do the caching at query level for similar results? The data is loaded daily so the cache would only have one day life.
Thanks for your help.
Bill
Well, the way it should work, please correct me if I am wrong, if there is a broader dataset in the cache when someone goes to drill down or filter it should use the dataset in Cache (as long as it hasn't been marked as dirty/old), which would be returned much faster then if it had to go and get the data directly.
So, in order to help percieved query performance, you can "prime the cache", by executing the queries after data is loaded w/ some general query variants to get the cache filled w/ data prior to users using it.
(Obviously you should also make sure you have good aggregates on the query that are used)
You can use the Reporting Agent, under Printing to run some broader queries to prime the cache. Just set the printer to nothing so nothing is outputted and those results will go into the cache.
To get fancy about it, you can create some RA Print jobs and schedule them via trigger, and then in your data loading PC's, use an ABAP to raise that trigger when the loads are finished to prime the cache.
- Stephen[/i]
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
Thanks you Stephan. That was a great help. I'll try all these tricks and give you feed back on what worked the best. Thanks again.
BG
Answer:
Well, the way it should work, please correct me if I am wrong, if there is a broader dataset in the cache when someone goes to drill down or filter it should use the dataset in Cache (as long as it hasn't been marked as dirty/old), which would be returned much faster then if it had to go and get the data directly.
Hi SBobcat and SAPfans,
Your reply is excellent advice and I have set up our system much like you describe. The reporting agent is part of a process chain firing several times each day to ensure that queries are cached.
The process chain is run with a systemuser 'aleremote' that has the nessesary autorizations to run queries, cubes etc.
My question is: If a user with limited authorization (lets say a matrix between product group and company code) runs the same query - should he benefit from the what ALEREMOTE cached prior?
When testing the set up and running the queries with a user with limited authorizations my results havnt been positive. It looks like the queries hit the aggregates and that performance is not improved. Of course when running the same query with the test user again - shows clear performance improvement telling me that the query now is cached and that the user can reuse it.
Does anybody have experience with a similar setup and autorizations?
/best rgd.
Answer:
well, if you guys have version beyond 3.x and want to start using new features, you can really implement the "Web Templates" in RA.. but ofcourse, you have to schedule it as a WebTemplate and they run perfectly with the views...
Now we are gathering the user navig/drill down options to help them better..
Mavip