TM1 Function for TI, SubsetAttrNL
Retrieves a value from a subset’s numeric attribute based on the local language code.
What is the SubsetAttrNL function?
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.
Where can the SubsetAttrNL function be used?
TurboIntegrator
What is the syntax for SubsetAttrNL?
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.
A demonstration on how to use SubsetAttrNL
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’.