Category Archives: Errors

These posts explore different errors that we have encountered in TM1 and how we resolved them.

Errors Connecting to Planning Analytics for Excel/CAFE

Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we run through how to get it all sorted!

TM1/Cognos Security Integration Gremlin

Weird. That’s all I can say. We have been doing a significant project with complex calculations done in TM1 and a front end with Cognos BI reports. We now have the integration working perfectly with TM1 cubes performing brilliantly in BI, TM1 cubes able to have data entered into them from Cognos Workspace and security integrated from multiple AD servers via Cognos groups and roles to both Cognos and TM1. Integrated … Continue Reading

TI Connection Error to Cognos BI Report

We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually do this when we have both TM1 and BI deployed at a client and it just makes sense to prepare the data in Framework Manager so it can then be used by any BI report and by TM1 as well. It especially cuts down reconciliation because if it is right in one … Continue Reading

Ambiguous Element Name: TM1 Rule Error

Saving a TM1 rule and getting an error “element name ambiguous”? Here is how to fix it and the trick the other posts on the internet fail to tell you about!

String Rules Invalid Expression

What do you do when you get an ‘invalid expression’ error when saving a rule based on a string element? This post dives into the best way to solve this error message with an example of the correct syntax.

TI Error: Cannot convert field number 9

I was working on a new TI process today and got this error – “Cannot convert field number 9, value “*textdata*” to a real number”. Odd, I thought. Cryptic error – cannot convert field number 9! I initially thought it might concern field number 9 in my source data.  Nope.  No cigar! What this is saying is that there is a field on the Variables tab has been defined as … Continue Reading

“cell type is real” TM1 Error

I got a “cell type is real” error this afternoon and was somewhat confounded! “cell type is real” was in the TM1 error log when I after I ran a TI process that was pasting a string into a cube.  The error was caused by the element I was trying to write to being defined as a “Simple” rather than “String” element.  Edited my dimension, made it String, re ran and all … Continue Reading

TM1 Performance Modeler Not Opening

I have been battling with opening Performance Modeler for a couple of weeks where I would start the application, get the “log on as” screen, put my details in (that are valid), select the server and click Ok. Then the status bar on the splash screen advances to about 20% and then it hangs. Very, very frustrating! I spoke with IBM who eventually suggested a solution that worked. Here is … Continue Reading