Add a new hierarchy to a dimension

Add new hierarchies to a dimension when you need to organize data in the dimension more granularly.

Complete the following steps to add a new hierarchy to a dimension.

1. Log into the Pentaho User Console (PUC).

2. Open the Semantic Model Editor by taking one of the following actions:

   • If you are using the Modern Design of PUC, in the menu on the left side of the page, click Semantic Model Editor.

   • If you are using the Classic Design of PUC, click File > Semantic Model Editor.

   The Semantic Model Editor opens.

3. Open the semantic model that contains the cube with a dimension you want to edit by completing the following sub steps:

   1. In the Semantic Models list, navigate to the model you want to open by searching or scrolling through the list.

   2. Click Open. The model opens in the canvas.

4. On the canvas, locate the cube, dimension node, and dimension you want to add the new hierarchy to.

   Note: To locate an element in a large semantic model, you can click the Model Structure tab and then navigate to the element by searching or scrolling through the list.

5. Click any of the More Actions icon available in the respective Dimension structure and select Edit. The Dimension Editor window opens for that dimension.

6. If not yet selected, select the Dimension in the tree. Click Add New Hierarchy. A new hierarchy is added to the dimension with the name “Hierarchy” and a number representing the order in which the hierarchy was added to the dimension. For example, “Hierarchy2” is the second hierarchy added to the dimension.

7. Click Apply. Edits to the dimension are applied.

8. In the Semantic Model Editor, click Save to save changes to the model.