Creating a Level-Based Hierarchy
Use level-based hierarchies when your data is organized into levels, such as Product Category, Product Group, and Product. When the data is displayed in a story, hierarchies can be expanded or collapsed.
Context
Procedure
To create a level-based hierarchy in the data-preparation stage
-
Start creating a model.
After the initial raw data import, you'll see the data integration view, where you perform data preparation before creating the model.
- In the toolbar, select (Level Based Hierarchy).
- In the Hierarchy Builder, type a name for the hierarchy.
-
Select columns to build your hierarchy.
You can drag the column tokens to change the order of the levels.
-
Select Generate a 100% unique bottom level for my hierarchy if the
data values in the lowest level don't correspond to unique dimension member IDs;
in other words, a single dimension member has multiple hierarchy parents.
For example, let's say you want to build a dimension with a level-based hierarchy using these two columns:
City Country Vancouver Canada Vancouver USA Seattle USA When you create the hierarchy, a new column is generated, with unique values that serve as the dimension member IDs:
City-ID City-Description Country Vancouver-Canada Vancouver Canada Vancouver-USA Vancouver USA Seattle-USA Seattle USA Note that when you subsequently import data into this model, this dimension member ID needs to be mapped from the imported source data as well. If the source data doesn't already have a column that contains such values, you can generate the dimension IDs again by selecting the card that represents the dimension member IDs of the dimension, and selecting Generate and Map the Unique ID.
-
Select OK when finished.
To see detailed information about the new hierarchy, select the hierarchy column. Information is shown in the Details panel.
- If you want to add more level-based hierarchies, or copy, edit, or delete a hierarchy, select (Level Based Hierarchy) to open the Hierarchy Builder again.
- When you've finished creating hierarchies, select Create Model.
- In the Modeler, switch to the Model view.
-
Open a dimension that you've created a level-based hierarchy for.
You'll see the hierarchy you created in the Dimension Settings panel. If you want to make any changes to the hierarchy, select the hierarchy to open the Hierarchy Builder.
To create a level-based hierarchy in the Modeler
- Import data and create your model, or open an existing model.
- In the Modeler, switch to the Model view.
- Open a generic or organization dimension.
-
In the Dimension Settings panel, select Create
Hierarchy Level-Based Hierarchy.
If other level-based hierarchies already exist, select one of them to open the Hierarchy Builder.
- In the Hierarchy Builder, select , and then type a name for the hierarchy.
-
Select columns to build your hierarchy, and select OK
when finished.
You can drag the column tokens to change the order of the levels.
- If you want to add more level-based hierarchies, or copy, edit, or delete a hierarchy, select (Hierarchy Management).