TM1 Function for TurboIntegrator, SubsetCreateByMDX

Where can the SubsetCreateByMDX function be used?


Which TM1 Server version is this function available for?

Version 11 and 12

What is the SubsetCreateByMDX function?

SUBSETCREATEBYMDX creates a public subset based on a MDX statement. 

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 of how to use SubsetCreateByMDX

Learn how to use the GET and POST methods with Post Test Server, in addition:
– HttpResponseGetStatusCode: returns the status code
– HttpResponseGetHeader: returns headers
– HttpResponseGetBody: returns the body