Add or Modify a Logical Column

You can add a new column to a logical table, or update an imported column's properties.

In most cases you create logical columns by dragging a physical table from the physical layer to the logical layer. This action creates a logical table with logical columns based on the physical table and its physical columns.
  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.
  4. In the Logical Layer pane, browse for and double-click the table where you want to add or modify a column.
  5. In the logical table, click the Columns tab.
  6. Click Add Column Add column icon and specify how you want to add the column:
    • Click Create New Column to create an empty column.
    • Click Add Physical Column and in Select Physical Column browse for and select one or more columns. Click Select.
  7. Optional: To duplicate a column, in the column table, hover over the column you want to duplicate and click its Row Menu and click Duplicate.
  8. In the column table, click a column to highlight it, and then click Detail view to view or modify its properties.
  9. Specify the column's properties.
  10. Click Save.