Discussing all things TM1, Planning Analytics, PAx and PAW
https://www.tm1forum.com/
Look in the Help documents for the TI function SubsetCreatebyMDX.bunchukokoy wrote: I just wanna know, is there a way I can write an MDX in the Expression window via TI? And if there is, can you please mention how. Thanks!
9.5.1 Reference Guide (verbatim) wrote:SubsetCreateByMDX
This is a TM1® TurboIntegrator function, valid only in TurboIntegrator processes.
This function creates a public subset based on a passed MDX expression.
Syntax
SubsetCreatebyMDX(SubName, MDX_Expression);
Argument
Description
SubName
The name you want to assign to the subset.
MDX_Expression
An MDX expression that returns a subset.
Example
SubsetCreatebyMDX('0-level months', '{TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [month] )}, 0)}, ASC)} ' );
This example creates a public subset named '0-level months' based on an MDX expression that returns a subset consisting of all 0-level elements in the Month dimension, sorted in ascending alphabetical order.