ATTRS TM1 Function: Use and Syntax within TI and Rules

ATTRS Syntax and Function


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 of ATTRS is:

ATTRS (dimension, element, attribute);


  • 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


Assume that the variable sPeriod contains “Jan”.

An example of the use is:

ATTRS ('Period', sPeriod, 'Period No');

which will return the string value for the period number (in our case “01”) for the month “Jan” from the dimension “Period”. Pretty easy huh!

The ATTRS function can be used in both Rules and TI processes.

To retrieve the value of a numeric attribute, please use ATTRN.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.