Category Archives: TM1Top

Installing TM1 Top

Have you ever wanted to use TM1 Top with Cognos Express?  Well as of 10.2 it is not available by default in CX.  You might even be wondering why you would want to use TM1Top?  Well, if like me, you have created a process that has then sent the server into a tail spin and need to kill it, then you will need TM1 Top. The trick for installing TM1 … Continue Reading

This entry was posted in Administration, TM1 Admin, TM1 Administration, TM1Top. Bookmark the permalink. | 1 Comment

Using TM1 Log Files

This is a great explanation of the different types of logging within TM1 for setting the different logging options to DEBUG mode.  This article was written for people to submit logs to support, however is a great explanation of logs in TM1. For most TM1 Logging, they can be modified so you are not recording at DEBUG level, but rather at a higher, less granular level. The source of this … Continue Reading

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

How to Restart TM1 or Cognos Express Safely

Sometimes we may need to restart the TM1 or Cognos Express server, or individual components of it.  You might need to do restart TM1 or Cognos Express if it has become particularly non responsive. Remember that TM1 is an in memory product, so if you just kill the server, you will lose all data entered since the last server based Save (which are scheduled, but still!). The steps are: Connect to the … Continue Reading

This entry was posted in Administration, TM1 Administration, TM1Top. 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

TM1: Top N Elements from a Tuple

Writing MDX statements is a very helpful skill for a TM1 person, but what if you need to automate this task and generate many MDX statements? TI process in conjunction with excel formulas might save you in this tricky situation. Say the requirement is to have Top 5 lists of products in each product category or in each country or Top 3 products for Top 3 product categories. In this … Continue Reading

This entry was posted in Elements, TM1Top and tagged TM1Top. Bookmark the permalink. | Tagged TM1Top | Leave a comment