Add a Dimension Level to the Preferred Drill Path

You can use the Preferred Drill Path field to identify the drill path to use when users drill down in their data requests.

You should use a preferred drill path only to specify a drill path that's outside the normal drill path defined by the dimensional level hierarchy. A drill path is most commonly used to drill from one dimension to another. You can delete a logical level from a drill path or reorder a logical level in the drill path.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer and locate and double-click the logical table that you want to add a drill path to.
4. In the logical table, click the Hierarchy tab.
5. Click a logical level, go to the Preferred Drill Path field, and click Add Table.
6. In Select Logical Level, search for and select a logical level, and then click Select.
   You can select logical levels from the current dimension or from other dimensions.
7. Click Save.