Category Archives: Attributes

DimensionElementPrincipalName, Syntax and Use

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

TM1 Clear Attribute – an AttrClear Function

The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example

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.

Days in Month – How to Easily Calculate in a TM1 Rule

Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.

CreateHierarchyByAttribute Function in TM1: Syntax and Use

Here is a great way to create virtual dimensions in TM1 based on attributes. These allow you to intersect multiple virtual dimensions from the same physical dimensions in a PAW or PAX report. Here we discuss the CreateHierarchyByAttribute function and give an example on how to use it.

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

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

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

AttrPutN TM1 Function: Use and Syntax

AttrPutN is a TM1 Turbo Integrator function that inserts a numeric value onto a specific attribute for the current element in a specified dimension. Note that this function does not insert a string into an attribute. To insert a string value into an attribute please see AttrPutS. Syntax of AttrPutN The syntax is AttrPutN(Value, DimName, ElName, AttrName, [LangLocaleCode] ); value, is the number that you want to insert dimname, is the dimension that you want … Continue Reading