Bedrock.Dim.Sub.Create.Consolidation.Leaf

This Bedrock TM1 TI will create a subset of leaf (level 0) elements that are descendants of the consolidated element. 

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.

pConsol

String


The consolidated element that members of the subset must be descendants of.

pAddToSubset

Boolean

0

0 = Add the elements to an empty subset.

1 = Add the elements to an existing subset.

pExclusion

String


Elements to be excluded from the subset.

pDelimiter

String

&

The delimiter to separate multiple elements to be excluded.

pDebug

Numeric

0

The debug mode.


Example

ExecuteProcess('Bedrock.Dim.Sub.Create.Consolidation.Leaf',

       'pDimension','Business Unit',

       'pSubset','By Regions Leaf',

       'pConsol','Regional',

       'pAddtoSubset',0,

       'pExclusions','Other',

       'pDelimiter','&',

       'pDebug',0

    );


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