You can set the following controls to determine how multiple SQL statements are handled:
| Option | Description |
|---|---|
| Multiple SQL statements for each context | Enables end users to create queries that contain multiple SQL statements when using a context. Select this option if you have any contexts in the universe. |
| Multiple SQL statements for each measure | Splits SQL into several statements whenever a query includes measure objects derived from columns in different tables. See the section Using Multiple SQL Statements for Each Measure for more information on using this option. If the measure objects are based on columns in the same table, then the SQL is not split, even if this option is checked. |
| Allow selection of multiple contexts | Enables end users to create queries on objects in more than one context and to generate one set of results from multiple contexts. If you are using contexts to resolve loops, chasm traps, fan traps, or any other join path problems, then you should clear this check box. |