Creating drill-down analysis with hierarchies

Defining which groups in your logical model have a hierarchical relationship enables Insight Advisor to offer breakdown analysis along specified hierarchies and better detect dependencies among groups.

Logical model hierarchies are created and managed in Hierarchies. Hierarchies are optional for business logic.

Hierarchies enable drill-down breakdowns in recommendations (such as Sales by Product category, Product sub-category, and Product). Hierarchies also help Insight Advisor avoid mixing geographic items in recommendations. For example, creating hierarchies for Supplier County with Supplier City and for Customer Country and Customer City prevents them from being used in erroneous combinations such as Supplier Country and Customer City.

Hierarchies are also used in associative insights to detect dependencies when making selections. For example, selecting Sweden in an Insight Advisor analysis and then having only Swedish city values be selected in another chart that uses the City field.

You can edit or delete hierarchies by clicking and selecting Edit or Delete.

Creating hierarchies

Do the following:

1. Click Create hierarchy
2. Enter a hierarchy name.
3. Add groups to the hierarchy in order from lowest level in the hierarchy to the highest level of the hierarchy.
4. Click Create.