Add or Remove Cube Columns in a Hierarchy Level

Dragging and dropping a cube table into the physical layer includes all of the table's objects. You can add or remove associated columns in the imported hierarchies.

You can choose to add any of the dimension property columns to a dimension hierarchy level. When you remove a hierarchy level column, Semantic Modeler converts it to a dimension property column.

In some cases you might need to create the column that you want to add to the hierarchy. When you create a column, Semantic Modeler adds it as a dimension property column that you can then add to a hierarchy level.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon.
  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 where you want to delete or add a column.
  5. To delete a column, go to the Associated Columns field, hover over the column to remove, and click Remove Associated Column Delete key button.
  6. To add a column, click Add Associated Columns Create icon to browse for and add a column.
  7. Click Save.