TM1 Function for TI, HierarchySubsetDeleteAllElements

Deletes all elements in a subset from a hierarchy.

What is the HierarchySubsetDeleteAllElements function?

HierarchySubsetDeleteAllElementsĀ deletes all elements in a subset from a hierarchy.Ā 

Where can the HierarchySubsetDeleteAllElements function be used?


What is the syntax for HierarchySubsetDeleteAllElements?

HierarchySubsetDeleteAllElements(DimensionName,Ā HierarchyName,Ā SubsetName);Ā ā€‹

ā€‹DimensionNameĀ = Name of the dimension the subset is made of.ā€‹
HierarchyNameĀ = Name of the Hierarchy the subset is made of.ā€‹
SubsetNameĀ = Name of the subset.ā€‹

Note: The subset must be public

A demonstration on how to use HierarchySubsetDeleteAllElements

UseĀ HierarchySubsetDeleteAllElementsĀ to delete all elements from theĀ DepartmentsĀ subset associated with theĀ EmployeeĀ hierarchy andĀ EmployeeĀ dimension.