Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle OLAP Hierarchical Tools

Oracle Database Tips by Donald Burleson

Hierarchy Handling Improvements

Enhancements include additional support for two primary clients, BI Beans and JOLAP, in terms of:

Hierarchical Sorting - The improved API allows the client to specify explicitly that a source be sorted hierarchically. This enhancement allows the client to specify a specific sort order within each level and to specify whether parents come first or last.

Multi-hierarchy Selections - The client can create dimension selections that contain members from multiple hierarchies. This is a requirement of BI Beans.

Hierarchically Aware Dimension Values - The ID of the hierarchy and level encoded in the values of a dimension member is a requirement for multi-hierarchical selections to work. It allows the application developer to write more efficient SQL queries.

Metadata Changes - The MDM (multi-dimensional model) client metadata model has been enhanced to provide objects that represent the notion of a shared level. This is a JOLAP requirement.

With Oracle Database 10g, Client has better control over the usage and selection of a hierarchy. Given a selection from a hierarchy and a self-relation representing the parent of each member of the hierarchy, the client is able to sort the selection hierarchically with either the parent or the children first. Also, the client can now specify a sort order for siblings by either attribute or measure values.

In 10g, it becomes possible to replace the hierarchy class with explicit subclasses. MdmLevelHierarchy represents hierarchies that are based on levels. MdmLevelHierarchy contains a list of levels, a ?level attribute?, and a ?level depth attribute?.

In order to support multi-hierarchy selections in Oracle Database 10g, some changes are introduced in the metadata. Now, the dimension itself dimensions parent attributes. Each hierarchy returns the same instance of MdmAttribute to the call getParentAttribute, and similarly for getLevelAttribute and getLevelDepthAttribute.

In 10g, all dimensions obtained from the getDimensions methods on MdmSchema and MdmMeasure are instances of MdmPrimaryDimension. An MdmPrimaryDimension is a new class used to represent top level, logical dimensions like ?Products,? ?Geographies,? and 'times.?



If you like Oracle tuning, you may enjoy my new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.