1. Building Semantic Models in Oracle Analytics Cloud
  2. Create and Build Your Model
  3. Build a Semantic Model's Physical Layer
  4. Delete a Physical Column

Delete a Physical Column

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

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.
  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.