IBM Support

Unexpected sorting results in some reports

Troubleshooting


Problem

On rare occasions, you might notice that data in some Cognos Analytics reports is not sorted. At the same time, sorting is enabled in the report source data module, which is indicated by the Members property on columns set to Automatic.

Resolving The Problem

To resolve the issue, manually change the Members property to Enabled in the following way:
  1. Open the report source data module.
  2. Locate the columns where the sorting issue occurs.
  3. For each affected column, in its Properties pane, on the General tab, set the Members property to Enabled.
  4. Save the data module, and run the report.
For more information about the sorting options in data modules, see the documentation.


Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m500000008d78AAA","label":"Reporting"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 July 2020

UID

ibm16253421