HierarchyAttrNL function for IBM Planning Analytics (TM1)
HierarchyAttrNL retrieves a numeric attribute from a dimension’s hierarchy given a language locale.
Where can the HierarchyAttrNL function be used?
TurboIntegrator
Which TM1 Server version is the HierarchyAttrNL function available for?
Version 11 and 12
What is the syntax for HierarchyAttrNL?
HierarchyAttrNL(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