TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​​SUBSETCREATEBYMDX

Available In



SUBSETCREATEBYMDX creates a public subset based on a MDX statement. 


SubsetCreateByMDX(DimName, SubName, [AsTemporary] )

DimName = Name of the Dimension where we are creating subset.  

SubName = Name of the subset that we want to assign to the subset.  

MDX_Expression = Query that builds the subset. 

[AsTemporary] = This is an optional parameter and mainly it is used to create temporary subset. The argument values are 1 and 0.

1 =  creates temporary subset;  0 = creates the permanent subset. 

Video Demo

Use SubsetCreatebyMDX to create a permanent and temporary subset based on a MDX statement in the Product Scorecard dimension.