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?