IBM Support

Unable to add two or more children of the same OLAP data hierarchy onto multiple fields of a crosstab

Troubleshooting


Problem

You are presented with a prohibited icon ? when you attempt to add a child of an OLAP hierarchy onto a field of a crosstab if another child from the same hierarchy is already present in another crosstab field.

Symptom

Test Case

  1. In IBM Cognos Analytics create a Crosstab and use an OLAP source (for example Go Sales Analysis)
  2. Add the level "Years" from the "Time" hierarchy to the Columns field.
  3. Add level "Years" or any other level from the "Time" hierarchy to Rows field.
You cannot add another level from the hierarchy called "Time" to the Rows field because the level called "Years" from the same hierarchy is already present in the Columns field.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Report","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF043","label":"Red Hat"},{"code":"PF048","label":"SUSE"},{"code":"PF031","label":"Ubuntu"},{"code":"PF033","label":"Windows"}],"Version":"11.1.6","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 July 2020

UID

ibm15967807