I want to store an organization Hierachy structure in a table using the Hierarchy data type i've just discovered.
Against each level of the organization are numeric values that i want to manipulate. What' i'm not sure of is if there are new functions to assist me in getting aggregations that group on the Hierarchy nodes.
For example. How would i get a sum/total of a numeric field from a table with a Hierarchy datatype if i wanted aggregation to occur 2 nodes from the top ? Do i use group by or rollup ? Or is there now some better cleaner way to do this ?