Skip to main content
System StatusContact Support Agility Community


This feature is available in Enterprise and Ultimate editions.

The project tree table allows you to relate parent and child projects.

Table Description

The following table describes the columns available in the table.

Column Name Description Datatype Foreign Key To
AncestorKey Datamart identifier for a parent Project int Dim.Project
DescendantKey Datamart identifier for a child Project below the specific AncestorKey int Dim.Project
Distance How far the child is away from the parent int  

The primary key for this table is formed by combining the AncestorKey and the DescendantKey.