HierarchySubsetElementExists
HierarchySubsetElementExists determines whether a specific element exists within a specific public subset on the server from which a TurboIntegrator process is executed. HierarchySubsetElementExists cannot be used to determine if an element exists in a private subset.
If the element exists in the specified subset, the function returns 1, otherwise it returns 0.
This function is valid in TM1® TurboIntegrator processes only.
Syntax
HierarchySubsetElementExists(DimName, HierName, SubsetName, ElementName);|
Argument |
Description |
|---|---|
| DimName | The dimension parent of the subset containing the element whose existence you want to confirm. |
| HierName | The name of the hierarchy in the specified dimension. |
| SubsetName | The public subset containing the element whose existence you want to confirm. |
| ElementName | The element whose existence you want to confirm. The ElementName argument only accepts the element name and not the alias. |
Example
HierarchySubsetElementExists('Region', 'Eastern', 'Europe', 'Italy');This example determines if the Italy element exists in the Europe subset of the Eastern hierarchy from the Region dimension.