If you have only measure objects defined for both fact tables, then you can use the Universe Parameters option Multiple SQL statements for each measure. This forces the generation of separate SQL queries for each measure that appears in the Query pane. This solution does not work for dimension and detail objects.
The following table describes when you can use Multiple SQL Statements for Each Measure and when you should avoid its use:
| You... | In these situations... |
|---|---|
| Use Multiple SQL Statements for Each Measure | In universes that contain only measure objects defined for both fact tables. The advantage of using multiple SQL statements is that you can avoid using contexts that you need to maintain later. |
| Do not use Multiple SQL Statements for Each Measure | When you have dimension or detail objects defined for one or both of the fact tables. If a dimension or detail object is included in a query based on a universe using this solution, a Cartesian product will be returned. As this solution can slow query response time and produce incorrect results, than you should consider creating contexts to resolve the chasm trap. |
To activate Multiple SQL Statements for Each Measure:
1. Select
File > Parameters from the menu bar.
The Universe Parameters dialog box appears.
2. Click
the SQL tab.
Select the Multiple SQL Statements for Each Measure check box in the Multiple Paths group box.
3. Click OK.