Skip to Content
0
Former Member
Aug 01, 2005 at 10:43 PM

Query Cache with Reporting Agent

45 Views

Hi,

I created a web report, a control query and a reporting agent Web template setting. Control Query is designed to have Plant in the row and Profit center hierarchy on the columns. Web Query is drilldown by Plant and Material.

With this, I thought I would be in a position to run the reporting agent once and access the subset of the data from the cache.

When I schedule the reporting agent for web template, I could see the results in transaction RSRAPS.

However, when I run the query from the browser with DATA_MODE=HYBRID and select a profit center hierarchy node with couple of plants, I see that the data is not being accessed from the cache rather it goes to get the data from the data base.

Would appreciate any help in fixing this problem.

VJ Sudharsan