Category Archives: Attributes

“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

Picklists in TM1 are a great way for you to ensure that users only “enter” (or in this case select) a value from a standard list of options. For example, you might want a user to enter a three character month like Jan, Feb, Mar etc. You could design your cube to have a text element and then ask users to enter periods in that format. This will work perfectly … Continue Reading

This entry was posted in Attributes, Cubes, Dimensions, MDX and tagged Picklists, TM1. Bookmark the permalink. | Tagged 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

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

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

This entry was posted in Attributes, TI Functions. Bookmark the permalink. | 2 Comments

AttrPutS and AttrPutN Doesn’t Work!

Attribute Definition Problem I just had an instance where I was adding new elements to a dimension in TM1 and then wanted to define an attribute for those new elements.  Easy, yeah?  Just test if an element is there with a Dimix, then use a DimensionElementInsert and then an AttrPutS or AttrPutN to define the attribute.  Well, not quite. I had it all on the metadata tab, but even though the … Continue Reading

This entry was posted in Attributes, TI Errors. Bookmark the permalink. | 3 Comments

AttrPutS TM1 Function: Use and Syntax

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

This entry was posted in Attributes, TI Functions. Bookmark the permalink. | 2 Comments

Attributes in TM1

I have been using attributes since I started working with TM1 and are often asked what are they and what are they used for. What are Attributes in TM1 TM1 Attributes are a way of adding relevant information to elements in dimensions. For example, an attribute of a date element might be the day of the week, or the number of business days passed in a month. Or for a … Continue Reading

This entry was posted in Attributes, Dimensions, TI Functions. Bookmark the permalink. | Leave a comment

ATTRS TM1 Function: Use and Syntax within TI and Rules

ATTRS stands for ATTRibute String, in other words it returns the contents of a string attribute from an element in a dimension in TM1. Syntax of ATTRS The syntax is ATTRS (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 the variable … Continue Reading

This entry was posted in Attributes, Rule Functions, TI Functions. Bookmark the permalink. | 5 Comments