Bedrock.Dim.Sub.Create

This Bedrock TM1 TI will add elements to a subset based on a number of criteria as follows:-

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 the element must be a member of to be added to the subset. If this parameter is left blank then all elements will be evaluated. 

pAttribute

String


The attribute to be evaluated. If this parameter is left blank then this criteria is not evaluated.

pAttributeValue

String


The value of the attribute the element must equal.

pLevelFrom

String

0

The lowest level in the dimension the element can have.

pLevelTo

String

20

The highest level in the dimension the element can have.

pExclusions

String


Elements to be excluded from the subset.

pDelimiter

String

&

The delimiter to separate multiple elements to be excluded.

pAddToSubset

Boolean

0

0 = Add the elements to an empty subset.

1 = Add the elements to an existing subset.

pDebug

Numeric

0

The debug mode.


Example

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

    'pDimension','Product',

    'pSubset','Audio Items',

    'pConsol','All Products',

    'pAttribute','Audio/Video',

    'pAttributeValue','Audio',

    'pLevelFrom',0,

    'pLevelTo',1,

    'pExclusions',

    'ViDMP3 & VidAudio',

    'pDelimiter','&',

    'pAddToSubset',0,

    'pDebug',0

    );


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