Bedrock.Dim.Sub.Create.ByLevel

This Bedrock TM1 TI will create a subset for each level of a dimension. The subset will contain the elements for that level. The name of the subset will be 'All Level' and the level of the dimension, for example: 'All Level 01'.

Parameters

Parameter

Data Type

Default

Explanation

pDimension

String


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

pSort

Boolean

0

0 = The subset will be sorted in the same order as the dimension.

1 = Sort the subset alphabetically.

pConvertStatic

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.ByLevel',

       'pDimension','Business Unit',

       'pSort',0,

       'pConvertStatic',1,

       'pDebug',0

       );


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