TM1 Internal dimension order and Cognos BI

[jaudouig]

Hi all,

Here is a new issue I am facing in my quest to integrate TM1 and Cognos BI.

Environment:

Cognos BI 10.1.1
TM1 9.5.2

TM1 cubes are used as data sources in Cognos BI.

Description of the issue:

To improve performance and memory usage, the dimension order of a cube have been changed via the Cube Optimizer wizard.
We did observe a performance improvement, however, in contradiction to what the IBM documentation claims, the dimension order in the BI front end (i.e. Analysis Studio) did change and as consequence doesn’t meet the users requirements.

Is this a normal behaviour? Is there a work around this?


Thanks a lot.

[lotsaram]

If the dimension order changed in analysis studio after performing cube optimization then this is a clear bug and you should raise a defect with IBM.

[jaudouig]

The order has changed surprisingly. An IBM SR will be raised.
Thanks

[jaudouig]

By the way, IBM came back to me claiming that this was the intended design. Disappointing.