TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​​SUBSETATTRNL

Available In



SUBSETATTRNL retrieves a value from a subset’s numeric attribute based on the local language code. If the attribute is not defined for the language code, then the function returns the base attribute value.


SubsetATTRNL(DimName, SubName, AttrName, [LangLocaleCode]);

DimensionName = Name of the Dimension.

SubName = Name of the subset.

AttrName = Name of the attribute which value we want to retrieve. 

LocalLangCode = This is an optional parameter which is used to specify the language locale code. 

Video Demo

Use SubsetATTRNL to retrieve the numeric attribute, No of Elements, from the ‘All Elements’ subset in the Product Scorecard dimension using local language code ‘fr’.