Dimension Best Practices

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.

DimensionExists: Checking if a Dimension is in TM1

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

Replicating a Dimension Hierarchy in Excel

For those of us still using earlier versions of TM1 where Active Forms are not available, below is…

The SwapAliasWithPrincipalName – TI Function

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.

3 Cardinal Rules of Sustainable TM1 Development

We sometimes get asked what are the three most important things to remember in TM1 development to make…

Dimension Maintenance Methods

There are four ways to maintain a dimension within TM1: Backend Editor Dimension Worksheets TI Process TM1 API…

Naming Conventions and Syntax

Within TM1 all objects names and contents are completely defined by the Developer. Cubes, Public Views, Dimensions, Public…

Dimension Worksheets

Dimension Worksheets are a great way to manage medium sized dimensions and attributes/aliases. All Worksheets (Dimension and Rule)…

Modifying a Dimension – Backend Editor

There are a few ways to update a dimension within TM1, the first is the simplest and most…

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement