Unresolved column references in data sets that are created or refreshed in 11.1.7.0

Cognos Analytics 11.1.7.0 data sets generate schema information where the column names are not consistent with those used in previous releases. This error is resolved in 11.1.7 FP1.

If you upgraded to 11.1.7.0, then created or refreshed a data set

Scenario: You upgrade to 11.1.7.0 and then

  • create a data set

    OR

  • refresh a data set that had been created in an earlier release

In this scenario, a dashboard or report that references the 11.1.7.0 data set may show this message:

Identifier not found 'name'.

where name is a column name in the data set.

Solution:

To resolve the column name references, see References to columns in data sets do not resolve in Cognos Analytics 11.1.7 (https://www.ibm.com/support/pages/node/6349499).

If you upgraded to 11.1.7.0 but did not create or refresh a data set in 11.1.7.0

You do not need to edit any data sets. However, you should upgrade to 11.1.7 FP1 or later to avoid encountering unresolved column references in data sets in the future.

Solution:

To download Cognos Analytics 11.1.7 FP1, follow the instructions in Cognos Analytics 11.1.7 Fix Pack 1 (https://www.ibm.com/support/pages/node/6335329).