Method and system for efficient data structure for reporting on indeterminately deep hierarchies

A system for deriving from hierarchical data a data structure having hierarchies based on a leaf node entity, the system comprising:

• a memory having hierarchical data stored thereon;
• and
• a processor in communication with the memory, the processor operable to:
• determine a reverse bridge table data structure for the hierarchical data, the reverse bridge table data structure including an association of all ancestor node entities of the hierarchical data for each leaf node entity of the hierarchical data and a hierarchical level for each association;
• determine an ordered listing of the associations of the ancestor node entities and each leaf node entity based on the hierarchical level for each association;
• and
• provide an output of a hierarchy table data structure including an ordered aggregation of the hierarchical levels for each of the leaf node entities.

A medium having machine readable program instructions stored thereon for deriving from hierarchical data a data structure having hierarchies based on a leaf node entity, the instructions comprising:

• instructions to determine a reverse bridge table data structure for the hierarchical data, the reverse bridge table data structure including an association of all ancestor node entities of the hierarchical data for each leaf node entity of the hierarchical data and a hierarchical level for each association;
• instructions to determine an ordered listing of the associations of the ancestor node entities and each leaf node entity based on the hierarchical level for each association;
• and
• instructions to provide an output of a hierarchy table data structure including an ordered aggregation of the hierarchical levels for each of the leaf node entities.