Skip to Content
0
Former Member
Dec 15, 2006 at 12:05 PM

How to Caching the querry results

20 Views

Hi All,

We have a requirement of caching the particular query results and get the results from the cache whenever the query is executed by user.

Let me explain clearly. we have a high level complex query which runs on the BW cube(BW 3.5). The query is having the lot of structure elements and each element is restricted and calculated with no of characteristic values. That means the query needs to read each and every detail of the data to get the output. Because of that aggregates are no longer useful. The query will takes 30-45 min for each run. Due to no of users running the report some time it is timed out.

Is there is any way we can run the report and save the results in some caching. so that when ever the user runs the query it should bring back the results from caching.This will save lot of users time.

Appreciate any kind of info on that.

Thanks in Advance..