Bedrock.Dim.Sub.Create.ByMDX

This Bedrock TM1 TI will create a subset using an MDX expression. This subset can then be converted to a static subset.

Parameters

Parameter

Data Type

Default

Explanation

pDimension

String


The name of the dimension where the subset is to be created.

pSubset

String


The name of the subset that the elements will be added to.

pMDXExpr

String


The MDX expression to create the subset

pConvertToStatic

Boolean

1

0 = The subset is created by an MDX expression.

1 = The MDX expression will be converted to a static subset.

pDebug

Numeric

1

The debug mode.


Example

ExecuteProcess('Bedrock.Dim.Sub.Create.ByMDX',

       'pDimension',

       'product',

       'pSubset','LA Products',

       'pMDXExpr','{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Product] )}, "*LA-*")}',

       'pConvertToStatic',1,

       'pDebug',0

       );


Copyright 2011, bedrocktm1.org Tested on: TM1 Versions 9.1 to 10.2.1 / Cognos Express 9.0 to 10.2