Monthly Archives: October 2017

How to Create a List Report using a TM1 Active Form

Use Active Forms to create dynamic list reports in Excel using TM1 data, that can be zero suppressed and allow users to expand and contract hierarchies.

This entry was posted in Active Forms, Excel, Perspectives and tagged Active Form, Excel, Perspectives, TM1 Perspectives. Bookmark the permalink. | Tagged Active Form, Excel, Perspectives, TM1 Perspectives | Leave a comment

Changing Element Order in a TM1 Dimension

How to set the order of elements in a dimension in TM1, either manually via the Dimension Editor, automatically via TM1 Server Explorer or within a Turbo Integrator process – and why you should be very careful when using it!

This entry was posted in Elements and tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element. Bookmark the permalink. | Tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element | Leave a comment

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