Exploring TM1 - a Chartertech Company
Search
Close this search box.

ATTRS TM1 Function: How to 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.

Note this is not AttrGetS! That function does not exist!


Syntax of ATTRS

The syntax of ATTRS 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 sPeriod contains “Jan” in a Period dimension with a string attribute called Period Long.

An example of ATTRS use is:

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

which will return the string of the long name for the period (in our case “January”) 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. For additional information about ATTRN, please click here.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In