TM1 Function for TI, ​SubsetExists

Checks if a public subset exists.

What is the SubsetExists function?

SubsetExists checks if a public subset exists. The function returns a 1 if the subset exists in the dimension, otherwise it returns 0.

Where can the SubsetExists function be used?


Which TM1 Server version is this function available for?

Version 11 and 12

What is the syntax for SubsetExists?

SubsetExists(DimName, SubsetName);​

​DimName = Name of the Dimension the subset is in.​
SubsetName = Name of the public subset that we want to check its existence. 

A demonstration on how to use SubsetExists

Use SubsetExists to check if two subsets exist in the in the Product Scorecard dimension.