TM1 Dimensions

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.

Attributes, TI Case Studies, TI Functions, tm1s.cfg, Virtual Dimensions

How to Create Virtual Dimensions in TM1/Planning Analytics

Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.

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.

Dimensions, TI Functions

DimensionCreate: How to Create a Dimensions in a TM1 Process (TI)

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

Attributes, TI Data Sources

"Joining" Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

Dimensions, Dynamic Reports, MDX

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.

Performance Modeller, Training

Generating a Time Dimension in Performance Modeller

Almost all TM1/Cognos Express applications will require a time dimension, and creating a time dimension has never been…

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

Dimension Worksheets

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

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