TM1 Function for TI, SubsetCreateByMDX
Creates a public subset based on a MDX statement.
Available In
TurboIntegrator
Definition
SUBSETCREATEBYMDX creates a public subset based on a MDX statement.
Syntax
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.
SubsetCreateByMDX creates a public subset based on a MDX statement.
TurboIntegrator
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.