Monthly Archives: August 2014

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

This entry was posted in Errors, Performance Modeler. Bookmark the permalink. | Leave a comment

Multi Threaded Queries (MTQ)

Much Faster Processing with MTQ in TM1 TM1 traditionally uses a single core or thread per task.  What this means is that when a user opens a view for a cube (or a TI or Cognos BI opens a view), that view is created by a single core.  Recently IBM changed TM1 so that it now can use multi threaded queries and it is almost a linear improvement in performance, roughly … Continue Reading

This entry was posted in Performance, TM1 Administration and tagged MTQ, multi threaded queries, performance. Bookmark the permalink. | Tagged MTQ, multi threaded queries, performance | 1 Comment

Annotations in TI Processes

When you first open up a Turbo Integrator script you will notice the text at the top of the Advanced tab tabs with a “#” in front of each line to show you the automated script that has been created. Use this as a prompt to then annotate what different sections of Turbo Integrator scripts do.  For example “#Convert date to sYear and sMonth” which could then be followed by the code to … Continue Reading

This entry was posted in TI Processes. Bookmark the permalink. | Leave a comment

Advanced Rules Editor

Turn on the Advanced Rules Editor in both TM1 and Cognos Express! It makes editing and creating rules sooo much easier! Find tm1p.ini in: C:\Users\YourUserName\AppData\Roaming\Applix\TM1C:\Users\YourUserName\AppData\Roaming\Applix\TM1 (note this is a hidden folder so you will need to type “\appdata” once you navigate to YourUserName and then continue to navigate to the correct folder). Here you should change AdvancedRulesEditor to be “T” rather than “F” and save the file. As the Advanced Rules … Continue Reading

This entry was posted in Rule Management, Rules. Bookmark the permalink. | Leave a comment

TM1Top in Cognos Express

I had a runaway process in TM1 today.  Took 8 hours to complete with a minor error in it on each row… I then couldn’t kill it short of restarting the server.  TM1Top would have allowed me to kill this process and go back to work This great little tool shows what is happening in TM1 and what users are connected at any one time.  It does not come with Cognos Express … Continue Reading

This entry was posted in TM1 Admin, TM1Top. Bookmark the permalink. | Leave a comment

Using a Framework Manager Package as a Data Source

You can use data published through Cognos BI as a data source for TM1.  I had heaps of trouble trying to make this to work. It was very frustrating, but I think worthwhile. So why bother I hear you ask first up. Well I reckon that in a combined BI & TM1 environment, having a data set that uses a common metadata layer for both BI and TM1 makes sense. … Continue Reading

This entry was posted in TI Data Sources. Bookmark the permalink. | 1 Comment

Turbo Integrator Variable Type Quick Change

What a great trick for assigning Variable Types in TI’s – thanks to MafiaMan for this. When setting up Variables in a TI process, you can select the type for all variables in the Variables tab just by dragging your mouse over them and then change the last one to, say “Other”. They will all get changed to Other. Somewhat faster than changing each variable individually!

This entry was posted in TI Variables. Bookmark the permalink. | Leave a comment

.pro files (no, not profiles, but “.pro files”

.pro files are a magic little file that is saved in the TM1 data folder (along with dimensions, models, feeders, cubes etc). You can read them with a text editor or email them to someone so they can scan your code and help with a problem (mine was a misplaced ENDIF!). Thanks guru for sorting that one while on the way to the airport!

This entry was posted in TI Processes. Bookmark the permalink. | Leave a comment

Welcome to Exploring TM1!

Hi, I’m John. Exploring TM1 is all about recording my journey from a TM1 newby to something beyond that. I have many years experience with business intelligence, performance management and data warehouses, but I am new to TM1.  So this is really about exploring TM1. The exploring TM1 blog is a record of my journey, the musings, frustrations, ah ha moments, tips and tricks, code, the “why is it so dumb” moments etc. … Continue Reading

This entry was posted in Exploring TM1 Site. Bookmark the permalink. | Leave a comment