If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cache query?

Started by dolsson5, 06 Apr 2009 01:52:55 PM

Previous topic - Next topic

dolsson5

I want to show many small bar charts in a grid.  Each row in the grid is a student.  Each column is a subtopic, showing a student's performance on questions within that subtopic.  Each chart shows a bar for each year the student was tested for that subtopic.

That all works fine, nesting the charts within a list and/or repeater table.  The problem appears when I include district average performance marks along with each bar in the charts for reference.  The report can take several hours to run.  I think the problem is that the district averages are fetched and recalculated for each chart.  This occurs even if I mark "Use Local Cache", probably because the query has to retrieve different values for each subtopic as it goes across the columns.  Never mind that the same half dozen subtopics are repeated for each row--I don't think the cache is smart enough to cache different versions of the same query.  Or is it?  Maybe I haven't found the right way to structure the queries yet.

Any ideas welcome, and thanks!

David

kawabunga

did you ever get a resolution to this problem? I'm facing the same issue.