Category Archives: Performance

Setting Dimension Order for a TM1 Cube

Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.

This entry was posted in Cognos BI, Cubes, Dimensions, Performance and tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance. Bookmark the permalink. | Tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance | Leave a comment

TM1 Stargate Views Explained

This is a fabulous article from our friends at Ironside in the US. The original article is available here. There are various approaches available to enhance the performance of your TM1 application. One such approach is to leverage Stargate Views. Stargate Views are different from traditional view objects and represent cached subsections of cubes that get created through user experience. As users browse cubes via the Cube Viewer or consume cube … Continue Reading

This entry was posted in Administration, Performance and tagged Stargate. Bookmark the permalink. | Tagged Stargate | 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