HierarchySubsetATTRN
HierarchySubsetATTRN returns a numeric attribute for a specified subset associated with a hierarchy in a dimension.
This function is valid in TM1® TurboIntegrator processes only.
Syntax
HierarchySubsetATTRN(DimName, HierName, SubName, AttrName);|
Argument |
Description |
|---|---|
|
DimName |
A valid dimension name. |
|
HierName |
The name of a hierarchy in a dimension. |
|
SubName |
The name of a subset in a dimension. |
|
AttrName |
The attribute for which you want to retrieve a value. This argument must be a valid attribute of the dimension. |
Example
In this example, the function returns the numeric value of the Accounting_Code attribute of the Sales subset from the Europe hierarchy in the Plan_Business_Unit dimension.
HierarchySubsetATTRN('Plan_Business_Unit', 'Europe', 'Sales', 'Accounting_Code');