Associate a Logical Column and Its Table with a Dimension Level

After you create all logical levels within a dimension, you associate one or more columns from the logical dimension table to each logical level except the Grand Total level.

The first time you add a column to a dimension it associates the logical table to the dimension. The drag and drop action associates the logical column with that level of the dimension. To associate the logical level with that logical column, drag a column from one logical level to another.

You must associate the logical column or columns that comprise the logical key of a dimension table with the lowest level of the dimension.

After you associate a logical column with a dimension level, the tables where these columns exist are displayed in the Tables tab of the Dimensions dialog box.

For examples, see: About Level-Based Measure Calculations and Grand Total Dimensional Hierarchy Example.

For time dimensions, ensure that all time-related logical columns in the source table are defined in the time dimension. For example, if a time-related logical table contains the columns Month Name and Month Code, you must ensure that both columns are defined at the appropriate level within the dimension.

  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 Logical Layer Logical layer icon and locate and double-click the logical table that you want to associate with a dimension level.
  4. Click the Columns tab.
  5. Click to select the logical column, and then click Detail View.
  6. Click the Level field and select a logical level, making sure not to select the Grand Total Level.
  7. Click Save.