Dimension Management

44 min total time

18 articles

3 authors

Start Reading

Playlist

Dimension Management

Managing dimensions is one of the most important activities for any TM1 administrator. In this series we present all our posts on how to manage dimensions in TM1, from inserting elements, rolling up, or consolidating, elements into structures, deleting elements, doing the insert and rollup on the fly in a TI, rather than in batch…

18 posts - 3 authors

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

Dimensions | TI Functions

DimensionDestroy: How to Delete a Dimension in TM1

Sometimes we want to just delete a dimension from TM1. We get lots of failed searches on our site...

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

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

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

How to Delete All Elements from a TM1 Dimension: DimensionDeleteAllElements

Have you ever needed to just delete all elements from a dimension in TM1? Well there is a super...

TI Best Practices

How to Unwind a Dimension in TM1

This is a case study of how to unwind a dimension without deleting all the elements. Includes...

Attributes | Elements | TI Functions

DimensionElementPrincipalName, How to Use and Syntax

DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in...

DimensionElementInsert TM1 Function: Use, Syntax and Examples

How to insert a new element into a TM1 dimension using a Turbo Integrator process. This post...

DimensionElementInsertDirect Function: Syntax & Use

DimensionElementInsertDirect directly adds a new element to a TM1 dimension immediately - no need...

DimensionElementComponentAdd TM1 Function: How to Use, Examples and Syntax

DimensionElementComponentAdd Function for use in TI Processes in TM1 and Planning Analytics to...

DimensionElementDelete Function TM1: Syntax and Use

Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete...

Elements | TI Functions

DimensionElementComponentDelete TM1 Function: Use and Syntax

DimensionElementComponentDelete selects a single element and deletes it from a consolidation...

Elements | TI Functions

DimensionSortOrder TM1 Function: Use and Syntax

Explanation and example of sorting a dimension in TM1 or Planning Analytics via a Turbo Integrator...

Dimension Best Practices

Dimension Maintenance Methods

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

Dimension Best Practices

Dimension Worksheets

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

Dimension Best Practices

Dimensions in TM1

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

Dimension Best Practices

How to Create Dimensions in TM1

In our post explaining dimensions, we said that they are one of the foundations of TM1. They are...