TM1 Function for TI, SUBSETATTRNL

Retrieves a value from a subset’s numeric attribute based on the local language code.

Available In

TurboIntegrator

Definition

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.

Syntax

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’.