(Oracle Express) To navigate up and down through the levels of aggregation in a dimension that has a hierarchy. When selecting dimension values or viewing data, you can expand or collapse a dimension hierarchy by drilling down or up in it. Drilling down expands the view to include child values that are associated with parent values in the dimension hierarchy. Drilling up collapses the list of descendant values associated with a parent value in the dimension hierarchy.
You can click a plus icon () to drill down on (expand)
the hierarchy or on a minus icon (
) to drill up on (collapse)
the hierarchy.
In the Selector, you can click the drill
icon () to display
the Drill dialog box so you can select a level of detail for the entire
dimension.
Copyright © 1984, 2005, Oracle. All rights reserved.