Dimensions in TM1
Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes to hold data. What are Dimensions? Dimensions in TM1 are just structured lists of elements (or sometimes known as members). So a list of product, months, customers, measures, years, accounts, cost centres, WBS codes, versions, […]
How to Unwind a Dimension in TM1
This is a case study of how to unwind a dimension without deleting all the elements. Includes simple TI code that you can use.
DimensionElementPrincipalName, How to Use and Syntax
DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.
How to Change 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!
Creating Dynamic Subsets in TM1
Dynamic Subsets in TM1 and Planning Analytics allow you to create sets of elements that always contain all relevant elements. For example, all children of a parent, or all level 0 elements. They are extremely useful in Dynamic Reports as with them you can be sure that all elements are displayed.
SwapAliasWithPrincipalName TI Function – How to Use and Syntax
Here we explain how to use the Swap AliasWithPrincipalName function in TM1 to swap the contents of an alias with the primary ID’s of a dimension.