Tag Archives: TM1 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

Guest Post: Solving a TM1 Performance Problem – Wim Gielis

One of our major customers was facing severe performance problems. The problems related to 2 cubes, in which we wanted to execute a rather tricky elimination. Please follow along while we discuss the cube architecture. We have an allocation cube with the following dimensions: Financial code (10 n elements) Year (2008, 2009, 2010, 2011, 2012) Month (12 months plus YTD consolidations) Scenario (actuals, budget rounds) Allocation phase (7 phases, populated … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis. Bookmark the permalink. | Tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis | 1 Comment