Tipz

Monday, January 28, 2008

TM1 and Excel Shut Down for No Reason

While working in TM1 I was in subset editor and clicked the keep button and all of a sudden TM1, and Excel disappear. I loose all my spreadsheet I have open. There isn't even a chance for the auto recover to save me. After getting over the frustration I go back into excel and get back to work and it happens again. I do not know why it happens, but here is how you can fix it.

1)Closed all running application.
2)Deleted C:\document and Settings\"User"\Application data\Applix\TM1\tm1p.ini.
*Location can change is you are running a updated version of TM1 under the Cognos directory.
3)Started Excel.
a) Received an Error.
b) Clicked OK.
4)Opened Server Explorer.
a) Error cannot locate admin host.
b) Clicked OK.
5)In Server Explorer went to File>>> Options.
6)typed in Admin Host name.
a)Update other settings in options you may want.
7)Click OK.
8) Works like a charm.
*I did loosed stored local servers in the options drop down but that is easy to fix.

0 comments: