Numbering Each Node According to Its Position in the Hierarchy (Doc ID 1365957.1)

Last updated on MARCH 08, 2017

Applies to:

Hyperion Data Relationship Management - Version: 11.1.1.2.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

You need a property that contains a number corresponding to the node's position in the hierarchy.

 A         1
 |---C     2
 |---D     3
 B         4
 |---E     5
     |---H 6
 |---F     7
 |---G     8


For example, you may wish to generate a code whose expected format is ZXnnnnnn (where nnnnnn is the number above padded to 6 digits).

 A     ZX000001
 |---C ZX000002
 |---D ZX000003
etc.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms