TI Functions

TM1 Function for TI – ATTRNL

Available In



ATTRNL returns a numeric attribute for an element in a dimension.


ATTRNL(DimNameElNameAttrName, [LangLocaleCode])

DimName – the dimension that you want to retrieve attribute value.

ElName – is the element in the dimension that you want retrieve attribute value.

AttrName – is the attribute of the dimension. 

LangLocaleCode – the language locale code to which the value applies. It’s an optional parameter. When it’s omitted, the base attribute value is updated.

Video Demo

Use ATTRNL to retrieve the index attribute from Monday in the Weekday dimension.