TM1 Function for TI, HierarchySubsetAttrSL
Retrieve data from a string attribute associated to a subset in a hierarchy, based on a language locale.
What is the HierarchySubsetAttrSL function?
HierarchySubsetAttrSL retrieves data from a string attribute associated to a subset in a hierarchy, based on a language locale.
Where can the HierarchySubsetAttrSL function be used?
TurboIntegrator
What is the syntax for HierarchySubsetAttrSL?
HierarchySubsetAttrSL(DimName, HierName, SubName, AttrName, [LangLocaleCode]);
DimName = Dimension Name
HierName = Hierarchy Name
SubName = Subset Name
AttrName = Existing Subset Attribute Name
LangLocalCode = Local Language Code listed in }Cultures control dimension
A demonstration on how to use HierarchySubsetAttrSL
Retrieve data from the Office attribute in the Benelux subset that’s associated with the Western Europe hierarchy and Sales Region dimension, using the language locale fr.