TM1 Function for TI, ​SUBSETEXISTS 

Checks if a public subset exists.

Available In



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


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. 

Video Demo

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