Writing MDX via TI

[bunchukokoy]

Guys,

Good morning!

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!

(You are highly appreciated)

bunchukokoy

[Alan Kirk]

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!

Look in the Help documents for the TI function SubsetCreatebyMDX.

[bunchukokoy]

Thanks! Allan,



bunchukokoy

[lotsaram]

RTM!

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.

[bunchukokoy]

Thanks guys!