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 on 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 on the drill icon ()
to display the Drill dialog box so you can select a level of detail for
the entire dimension.