Advantages of dimension hierarchy

Dimension hierarchies allow you to exercise a higher level of control over the number of follow-on queries that are presented to users as they navigate.

For example, in the flat dimension below, a navigation query on the Wine Type dimension value would return six possible refinement queries, one for each child.

This is a simple example, but a large flat dimension with many dimension values is too unwieldy to navigate. The user would be presented with too many potential follow-on queries.

Using hierarchical dimensions reduces this information overload and provides for an easier, more intuitive navigation experience. In the hierarchical example below, the Wine Type dimension value has only three possible refinement queries: Red, White, or Sparkling.

A second reason to use dimension hierarchy is that, by limiting the number of refinement queries, you decrease the amount of time it takes for the MDEX Engine to return its results. Returning query results that contain follow-on information for 20 refinement queries is faster than returning query results that contain information for 2000 refinement queries.
Note: The decrease in performance is due to network transfer and page size issues, not MDEX Engine computational speed.