Standard Hierarchy identifier (as opposed to Cost Centre Group)

[Former Member]

Within the tables SETHEADER, SETLEAF, SETNODE with setclass = 0101 I can identify the relationships between Cost Centres & their associated hierarchies.

All nodes/ groups are defined in here i.e. both those from the standard hierarchy & also those created as alternates (Cost Centre Groups).

How do I differentiate between the two i.e. is there a way to select only those nodes that are part of the standard hierarchy ?

Thanks

[Former Member]

Try SETHEADER-SETTYPE = B for sets created for general grouping of cost centers not necessarily part of cost center hierarchy and with "S" for standard hierarchy..

Regards,

Sudhakar

[Former Member]

This is not correct.

If I create a Cost Centre & assign to a node on the std hierarchy & also create a cost centre group & assign the same cost centre, within SETHEADER, both node entries have Set Type = B

B = Basic set (contain values and value intervals)

S = Single dinension set (Contain basic sets and other single-dimension sets that use the

     same dimension (the same table field). They are used to create hierarchies.

Any other advice ?