IBM Support

Limitations when reordering string dimensions in a TM1 cube

Product Documentation


Abstract

You may receive a 'Dimension re-ordering failed' error when attempting to reorder the dimensions in a cube.

Content

You should be aware of the following limitations when reordering dimensions in an IBM© Cognos© TM1© cube that includes a string dimension.

  • If the last dimension in the original order of dimensions is a string dimension, that string dimension must remain as the last dimension in the new order of dimensions. You cannot change the order of a string dimension that exists as the final dimension in a cube definition.
  • If the last dimension in the original order of dimensions is a numeric dimension, the last dimension in the new order of dimensions must also be a numeric dimension. You cannot replace a numeric dimension in the original order of dimensions with a string dimension in a new order of dimensions.
If you do not observe these limitations, you will receive a 'Dimension re-ordering failed' error when attempting to reorder the dimensions in a string cube.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27035784