Bedrock.Dim.Sub.Create.Attribute.All

This Bedrock TM1 TI will create a subset based on a value of an attribute. The process evaluates all elements in the dimension including consolidated elements. 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 of the element must equal to be included into 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.All',

       'pDimension','Business Unit',

       'pSubset','All 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