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

8.4 - Report Studio Generating Multiple SQL Statements

Started by JBACGCG, 27 Jan 2009 05:19:23 PM

Previous topic - Next topic

JBACGCG

I have created a star schema model composed of 3 query subjects. (1 fact and 2 dimensions joined 1:N) I am trying to write a report that places simple criteria on all 3 query subjects.

The performance is really slow. When I examined the report SQL I determined that the tool is generating  separate SQL statements for each query subject. This is results in a major performance hit.

Is there any way to force the combination of all three query subjects into a single SQL query?