HierarchySubsetExists

HierarchySubsetExists determines if a specific public subset exists on the server from which a TurboIntegrator process is executed. The function returns 1 if the subset exists on the server, otherwise it returns 0. Note that this function cannot be used to determine the existence of private subsets.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

HierarchySubsetExists(DimName, HierName, SubsetName);

Argument

Description

DimName The name of the dimension that is the parent of the subset whose existence you want to confirm.
HierName The name of the hierarchy within the dimension.
SubsetName The name of the public subset whose existence you want to confirm

Example

HierarchySubsetExists('Region', 'Industrialized, 'Northern Europe');

This example determines if the Northern Europe subset exists within the Industrialized hierarchy of the Region dimension.