TM1 Function for TI – SUBSETCREATEBYMDX
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.
Use SubsetCreatebyMDX to create a permanent and temporary subset based on a MDX statement in the Product Scorecard dimension.