Bedrock.Dim.Sub.Create.Attribute.Leaf

This Bedrock TM1 TI will create a subset of leaf elements based on a value of an attribute. This will evaluate only leaf elements in the dimension. If the value of the nominated attribute for the element equals the parameter value then the element is added to the 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.

pAttribute

String


The attribute to base the subset on.

pAttributeValue

String


The attribute value the element must have to be included in the subset

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 different elements to be excluded.

pDebug

Numeric

0

The debug mode.


Example


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

       'pDimension','Business Unit',

       'pSubset','Operational Units',

       'pAttribute','Type of Unit',

       'pAttributeValue','OP',

       'pAddToSubset',0,

       'pExclusions','',

       'pDelimiter','&',

       'pDebug',0

       );


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