Category Archives: Dimensions

Changing 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!

This entry was posted in Elements and tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element. Bookmark the permalink. | Tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element | Leave a comment

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.

This entry was posted in Cognos BI, Cubes, Dimensions, Performance and tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance. Bookmark the permalink. | Tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance | Leave a comment

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.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

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.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

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

This entry was posted in Attributes, Data Connection, TI Data Sources, TI Processes and tagged Attribute, Dimension, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Attribute, Dimension, TI Process, Turbo Integrator | Leave a comment

The Pick List – How to Create and Use Picklists in TM1

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 pick list so you can have in cell drop downs active inside TM1.

This entry was posted in Attributes, Cubes, Dimensions, MDX and tagged drop down, Picklists, TM1. Bookmark the permalink. | Tagged drop down, Picklists, TM1 | Leave a comment

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 in a dimension in TM1. Syntax of ATTRN The syntax is ATTRN (dimension, element, attribute); where: dimension is the dimension you want to interrogate element is the element you want to find the attribute for attribute is the name of the attribute you want to get the result of Usage Assume that … Continue Reading

This entry was posted in Attributes, Rule Functions, TI Functions. Bookmark the permalink. | 1 Comment

Creating Dynamic Subsets in TM1

Have you ever needed to have a TM1 subset that automatically includes all elements? What, I hear you say, doesn’t that always occur? Well no.  You can have static subsets (which is the default), or you can make dynamic subsets using MDX. And it’s easy! How to Create Dynamic Subsets using MDX Open Subset editor Turn on View, Expression Window Tools, Record Expression Manipulate elements to what you want Tools, … Continue Reading

This entry was posted in Dimensions, MDX. Bookmark the permalink. | Leave a comment

Display TM1 Attributes in Excel

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1 attribute in an Excel report is to use a DBRW, DBR or DBRA and refer to the control cube for the relevant dimension in the Excel formula. Example I have a dimension called Customer.  In this dimension there is an attribute called Channel. There is an element called “Fred Bloggs” (he’s a customer) and … Continue Reading

This entry was posted in Attributes, Excel. Bookmark the permalink. | Leave a comment

ELLEV TM1 Function: Use and Syntax

The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax The syntax is ELLEV(dimension, element); where: dimension, is the dimension you are interrogating, and element, is the element you want the level number for Use of ELLEV This function is used to determine the level of a specific element in a dimension.  It is often used in conjunction with an IF statement to … Continue Reading

This entry was posted in Elements, Rule Functions, TI Functions, TI Processes and tagged ATTRS, ELLEV, ITEMSKIP. Bookmark the permalink. | Tagged ATTRS, ELLEV, ITEMSKIP | Leave a comment