Generating the query SQL

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

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

Procedure

  1. In the table Properties, on the General tab, the Advanced section, locate the Item list property.
  2. Select one of the following settings:
    All
    The generated SQL contains all columns in the table.
    Used
    The generated SQL contains only the columns that are used by the query directly, and the columns that are needed by the join.
    Automatic
    This is the default setting. It works identically as the All setting.
  3. Save the data module.

Results

The query generation settings that you specify apply to queries in dashboards, reports, stories, and explorations.