HierarchyAttrSL function for IBM Planning Analytics (TM1)
HierarchyAttrSL retrieves a string attribute from a dimension’s hierarchy given a language locale.
Where can the HierarchyAttrSL function be used?
TurboIntegrator
Which TM1 Server version is the HierarchyAttrSL function available for?
Version 11 and 12
What is the syntax for HierarchyAttrSL?
HierarchyAttrSL(Dimension, Hierarchy, Attribute, [Locale])
- Dimension = name of dimension
- Hierarchy = name of hierarchy
- Attribute = name of attribute
- Locale = language locale code corresponding to the international language codes list in the }Cultures control dimension. If no locale is defined, the user’s current locale is used. An example of a language code is fr-CA, which is French-Canada.
Relevant Functions
- HierarchyAttrN = Returns a numeric attribute for a dimensions’ hierarchy
- HierarchyAttrNL = Returns a numeric attribute for a dimensions’ hierarchy, for a given language
- HierarchyAttrPutN = uploads data to a string attribute for a dimensions’ hierarchy
- HierarchyAttrPutS = uploads data to a numeric attribute for a dimensions’ hierarchy
- HierarchyAttrS = Returns a string attribute for a dimensions’ hierarchy
- HierarchyAttrSL = Returns a string attribute for a dimensions’ hierarchy, given a locale