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?


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.