Delete a Physical Column

Deleting a physical column deletes it from any physical alias tables that include the column.

For Essbase, if you delete an associated column from a physical level, Semantic Modeler removes the column from the physical level and adds it as a dimension property column in the physical hierarchy.

Instead of browsing to the physical column that you want to delete, you can search for it.

  1. On the 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 Physical layer icon.
  4. In the database pane, browse for and double-click the table with the column you want to delete.
  5. In the physical table, click the Columns tab.
  6. Locate the column that you want to delete, click Row Menu and click Delete.