TM1 Function for TurboIntegrator, SubsetCreateByMDX
Where can the SubsetCreateByMDX function be used?
TurboIntegrator
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