Modify a Hierarchy Level's Key

When you add an associated column to an Essbase cube table hierarchy level, by default Semantic Modeler uses the first column that you add as the level's key. You can choose a different column to use as the level's key.

For Essbase cube tables, each hierarchy level has a level key. The level key must match with the data source definition of the cube. In the physical pane, the icon for the column that you select first changes to the key icon after it's associated with the level of a hierarchy.

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 Physical Layer .
4. Browse for and double click to open the physical cube table and then from the Dimensions and Hierarchies pane, browse for and double click the hierarchy level containing the key you want to change.
5. Go to the Associated Columns field and confirm that it displays the column you want to set as the key. If the column you need is missing, click Add Associated Columns to add the required column.
6. In the level's properties pane, click the Key field and select the column you want to use as the level key.
7. Click Save.