The problem is this: in a cube view, if we try to stack more than 2 dimensions as row dimensions, and the data to be viewed is to be calculated, then the action will crash the server. TM1 is running as a service.Flash (Alert)
Abstract
A performance optimization put into TM1 9.4.1 FP2 creates the possibility of a server crash after deleting any cubes on the server.
Content
It is possible in the short term to set a configuration parameter in the tm1s.cfg that turns off the new behavior and would thus avoid this potential crash.
IBM Cognos support recommends anyone running 9.4.1 FP2 turn it off until a fix can be provided. It does require restarting the server after making the change.
Parameter to put in the tm1s.cfg:
InvalidateRuleDependenciesOnDataChange=T
or
InvalidateRuleDependenciesOnDataChange=True
Then restart the server.
I tested on my local which has not been applied with any Fix Pack, and this works fine. I did not apply FP2 on my local due to the issue with TM1 client on FP2 with server on FP2. This feature, being a bread-and-buttter function of TM1, should not have failed so spectacularly.
Anyway, I was quite happy to have found this IBM post and immediately tested it out. Result: FAIL.
I'm rolling back to Fix Pack 1 on my server now and hope this problem does not exist. But I hope that FP1 allows TM1 Web to display validation lists in Websheets, or else I have to redesign a whole bunch of worksheets! Wish me luck...
