Bedrock.Dim.Hierarchy.Create.FromAttribute

This Bedrock TM1 TI will create a hierarchy within the dimension based on the values of an text attribute. 


Depth in the hierarchy can be added by assigning the consolidated elements into the same hierarchy.


Parameters

Parameter

Data Type

Default

Explanation

pDimension

String


The dimension where the hierarchy is to be built.

pAttribute

String


The attribute that contains the values 

pTopNode

String


The name of the element at the top of the Hierarchy.

pPrefix

String


Optional: Characters to be insert before the attribute value. This will not change the element name.

pSuffix

String


Optional: Characters to be insert after the attribute value. This will not change the element name.

pUnwind

Numeric

1

The hierarchy will be unwound before been rebuilt from the attribute values. 

pEmptyConsol

Number

0

Optional: This will delete all empty consolidations in the dimension.

pDebug

Numeric

0

The debug mode.


Example


ExecuteProcess('Bedrock.Dim.Hierarchy.Create.FromAttribute',

    'pDimension','Cost Centre',

    'pAttribute','Finance',

    'pTopNode', 'Total Finance Managers',

    'pPrefix', '',

    'pSuffix', ' (Finance)',

    'pUnwind', 1,

    'pEmptyConsol', 0,

    'pDebug',0

    );


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