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

Create a Physical Table

Manually create a physical table when you can't import a data source table. You create a table to mirror a table in the data source, or to use a select statement or stored procedure to populate the physical columns you specify.

For information about how to set the table properties, see What Are a Physical Table's General Properties?

  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 Physical Layer pane click Create and then click Create Physical Table.
  5. In Create Physical Table, go to the Name field and enter a table name. Then go to Location and browse for and select the new table's location.
  6. Click OK.
  7. In the new table's tab, click General and specify the table's properties.
  8. Click Columns and depending on the source you specified, add the columns or enter a stored procedure or select statement to populate the columns.
  9. Click Save.