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.

To add a cube table for a multidimensional data source, see Create a Cube Table in the Physical Layer.

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 Physical layer icon.
  4. In the Physical Layer pane click Create Create icon 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.