TM1 Function for TI, HierarchySubsetAttrS
Retrieve a field from a string attribute from a subset tied to a dimension’s hierarchy.
What is the HierarchySubsetAttrS function?
Retrieve a field from a string attribute from a subset tied to a dimension’s hierarchy.
Where can the HierarchySubsetAttrS function be used?
TurboIntegrator
What is the syntax for HierarchySubsetAttrS?
HierarchySubsetAttrS(Dimension, Hierarchy, Subset, Attribute);
Dimension = name of dimension
Hierarchy = name of hierarchy
Subset = name of subset
Attribute = name of string attribute
A demonstration on how to use this function
Retrieve data from the Office attribute associated to the Benelux subset in the Western Europe hierarchy from the Sales Region dimension.