Bedrock.Dim.Sub.Exclude

This Bedrock TM1 TI will remove specific elements from a subset.

Parameters

Parameter

Data Type

Default

Explanation

pDimension

String


The name of the dimension where the subset exists.

pSubset

String


The name of the subset that the elements are to be excluded from.

pElements

String


The element to be excluded. Multiple elements can be specified by separating the elements using the delimiter character. If a consolidated element is specified then the consolidated element and all its descendants will be excluded from the element.

pDelimiter

String

&

The delimiter to separate multiple elements to be removed. 

pDebug

Numeric

0

The debug mode.


Example

ExecuteProcess('Bedrock.Dim.Sub.Exclude',

    'pDimension','Business Unit',

    'pSubset','Regional',

    'pElements','Other & Unspecific',

    'pDelimiter','&',

    'pDebug',0

    );


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