When sales data can drill by time, region, or product, the user needs to choose which axis to follow

What it is

One sales dataset can drill down by time (year → quarter → month), by region (nation → region → province), or by product. When several dimensions can all expand, the implied "click and drill" no longer holds — the system has picked a path on the user's behalf, and the user wanted another. The drill dimension must be explicitly selectable: ask on click, provide a dimension switcher, or drill the default while keeping the switch visible.

Why it happens

The need follows from combinatorial explosion: three drillable dimensions mean every node has three downward paths, an implicit default covers one, and the cost of the other two is silently raised — users detour (manually switching the dimension first) or give up. The default dimension is itself a silent design decision: a report defaulting to time-drill is awkward everywhere in a "which region went wrong" task. Explicit selection hands the path back to the task: the analytical question decides which dimension to expand, not an implementation default. The cost of the selection interaction must stay low — a popup on every click enrages frequent users, so the common shape is "default drills directly + a visible dimension switch."

Where it stops holding

Not every drill needs a dimension choice: single-dimension hierarchies (a pure org tree, pure time) have no choice to make. Two dimensions can share explicit dual channels (click the x-axis to drill dimension A, click the legend for dimension B), but the mapping must be labelled explicitly, or channel allocation becomes the next hidden decision. Defaults should be configurable (administrators set them by the primary task) and should remember the user's last choice. Cross-dimension mixed drilling (region first, then time) is a legitimate path, with breadcrumbs split per dimension (the third card in this group).

Applying it

• Provide a dimension selector for multi-dimension charts (popup on drill or persistent), with the default set to the product's primary task.
• Remember the chosen dimension and reuse it for the next drill within the session.
• Verification: have users "drill to product subcategory" when product is not the default; smooth switching and drilling means it holds — detours or a missing entry mean dimension choice is missing.

Related

• Same group: U6.05.1 Drill-down descends a predefined hierarchy from summary to detail · U6.05.2 Roll-up needs a return path as explicit as drill-down · U6.05.3 The current level position must stay visible · U6.05.5 Existing filters must be inherited and stay visible through drill-down
• Nearby: U6.01.2 Zooming and filtering are two ways to narrow scope · U6.10.3 Bookmarks must record filters and view configuration, not just page position
• Search terms: drill dimension choice · multidimensional drilling · OLAP slice dice