Techniques are described which allow function-defined hierarchies to be registered with a database server. The information provided to the server during the registration process is used by the server to determine how to roll up data that has been aggregated at one level of a function-defined hierarchy...http://www.google.com.au/patents/US6493708?utm_source=gb-gplus-sharePatent US6493708 - Techniques for handling function-defined hierarchical dimensions