Generating the query SQL

You can specify how Cognos® Analytics generates the SQL that retrieves data from tables.

Depending on the setting that you specify for the Item list property on tables, the generated SQL query includes all or only selected columns.

For more information, see Generating the query SQL.