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":"BU048","label":"IBM Software"},"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":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
14 January 2026

UID

ibm15967807