Dimension Best Practices

Dimensions in TM1

Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and…

Cognos Analytics, Dimension Best Practices, 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.

Dimension Best Practices, TI Functions

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.

Dimension Best Practices, Dynamic Reports, Training

Replicating a Dimension Hierarchy in Excel

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

Dimension Best Practices, Elements, TI Functions

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.

Dimension Best Practices, Elements, TI Best Practices

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 Best Practices

Dimension Maintenance Methods

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

Dimension Best Practices, Elements

Naming Conventions and Syntax

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

Dimension Best Practices

Dimension Worksheets

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

Dimension Best Practices

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