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.

What is the SubsetCreateByMDX function?

SubsetCreateByMDX creates a public subset based on a MDX statement.

Where can the SubsetCreateByMDX function be used?

TurboIntegrator

What is the syntax for SubsetCreateByMDX?

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. 

A demonstration on how to use SubsetCreateByMDX

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