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

Query runs twice

Started by tupac_rd, 24 Jun 2008 10:24:20 AM

Previous topic - Next topic

tupac_rd

Hi Gurus,

I have a Report Studio (Cognos 8.3 SP1) report, with 2 pages. The 1st page is a list report with detail data and the 2nd page is a list report with summary data. Both the lists are using the same query. But when I run the report, the query is running twice once for each page. Is this Cognos behavior or is there a workaround to make the query run only once instead of 2 times.

Thanks
dd

rockytopmark

Running as designed!

Each list object requires a resultset.  The fact you have 1 query definition to provide you with both resultsets, doesn't alleviate the need for the unique SQL for each object to be requested.

Since you are on 8.3, setup concurrent query processing, if your goal here is improve time to render.

Other solution is to eliminate the Summary list and incorporate some summary information (aggregation) within the detail list's footer(s).

tupac_rd

Hi,

Thaks for the reply.
To elaborate more, the common query has 8 columns. Columns 1 through 7 are code, description and other attributes. Column 8 is a count.

The list on the 1st page would display all columns and it might span more than one page. The summary page would display only columns 1, 2 and 8.

So, in such a scenario, I was assuming Cognos would send the query to the database only once and the rendering of the results on the 2 pages is handled by Cognos.

Can you please let me know if there is one best way to handle this.

THanks
dd

rockytopmark

You are already handling it well.  You have one Query object to maintain, rather than 2.

Like I said in my previous post, the best posssible scenario IMO, is to merge the summary information to be part of the detail list, so you get your single SQL request.