Reverting to missing values in list reports

Applies to version 11.1.7 and subsequent versions unless specifically overridden. The format property Missing Value Characters defined in Framework Manager models is now honored in list reports.

About this task

In previous releases, when the Missing Value Characters format property was defined against an item in a Framework Manager model, it would get applied for crosstab reports, but not for list reports. In other words, null values for the given model item would appear as blank in a list report instead of displaying the characters defined in the format property Missing Value Characters. This was not the desired behavior and has been rectified for release 11.1.7.

If you wish to revert to the Cognos Analytics behavior that was exhibited prior to release 11.1.7, follow this procedure:

Procedure

  1. Stop the IBM Cognos Analytics service.
  2. Go to installation_location\configuration
  3. If the file xqe.config.custom.xml does not yet exist, copy the file xqe.config.xml and rename it xqe.config.custom.xml
  4. Edit xqe.config.custom.xml:
    1. Immediately after the <queryPlanning> line, add the following line: 
      formatMissingValuesInListReports enabled="false"/>
    2. Save xqe.config.custom.xml.
  5. Restart the IBM Cognos Analytics service.