Dimensions

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!

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.

Using the DimensionCreate Function to Create a Dimension in TM1

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

Checking if a DimensionExists in a TM1 Model

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

"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.

AttrInsert TM1 Function: Use and Sytax

Sometimes we want to create a new attribute in TM1 dynamically during the execution of a TI process….

Picklists in TM1

Picklists in TM1: How to Create and Use Them

Using Picklists in TM1 is a great way of ensuring data quality. We explain different types of pick lists, why you use & how to create each type of picklist so you can have in cell drop downs active inside TM1.

ATTRN TM1 Function: Use and Syntax within TI and Rules

ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element…

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.

Display TM1 Attributes in Excel

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1…

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