Author Topic: 8.4 - Report Studio Generating Multiple SQL Statements  (Read 552 times)

Offline JBACGCG

  • Associate
  • **
  • Posts: 1
  • Forum Citizenship: +0/-0
8.4 - Report Studio Generating Multiple SQL Statements
« on: 28 Jan 2009 05:19:23 am »
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?