TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​​​SUBSETEXISTS 

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.