HierarchyBelongsTo Help

[Anonymous]

Hi All,

I'm trying to create a visual scatter chart with HierarchyBelongsTo .  I need some help on how to define the "ID", ParentID" and "Node" from the load script. Please see attached Excel highlighted in green.

HierarchyBelongsTo(id, parentid, node, 'ancestorid', 'ancestor', 'layer')

Many Thanks,

Frank

[Chanty4u]

chk dis

Hierarchy Belongs to

Hierarchy and Hierarchy Belongs to

[Anonymous]

Thanks! It's helpful. I wish Jagan's example comes with the excel spreadsheet.  What I'm trying to get from the load scripts are the ParentID and ChildID.

[jvishnuram]

Hi Frankie,

look at the attachment,

[Anonymous]

Thanks Vishnuram! I'm checking it out right now.

Can you show me how this works in a visual chart?