running a report with multiple queries and data containers

[damzI]

So i have this complex dashboard in Report studio (10.2.1) using 6 charts, each with its own query and prompts.
So when I run each chart individually they take about 3-6 seconds. But when I run the whole report with the 6 charts it takes 25-30 seconds.
Is there a setting to have the whole report run together to reduce my run time ?

[Michael75]

Hi damzI,

Since your request hasn't received a reply yet, I'll propose my solution. This is based on a few assumptions:

a) When you say that each chart/query has its own prompts, I'm assuming that you mean that each has its own hard-coded filters. I can't imagine a dashboard where the user has to fill out six sets of prompts before seeing the results  :o
b) The six charts in your dashboard have some common elements, i.e. columns shared between them
c) There may be some global filters which apply to all six queries
d) There are probably specific filters which apply to each query

What I'd do is:

1. Make a spreadsheet showing charts vs columns. This will give you a list of all the columns used. Having done that, establish what (if any) are the global filters.
2. In Report Studio, create a main query ("qry_Main", "q_General" or whatever), which contains:
  - all the columns used
  - the global filters (if applicable)
3. Within the Query Explorer, create six new detail queries ("qry_Chart1" thru "qry_Chart6" or whatever), each of which is fed by the main query
4. Apply the specific filters to each detail query as necessary
5. In Page Explorer, associate each chart object to the relevant query

This should ensure that a single query is sent to the DB.

Post back with your results.

HTH
Michael