Create a Physical Alias Table

An alias table uses another physical table as its source. You can use an alias table to create an alternative name for its source table. For example, if you imported a table named SAMP_TIME_DAY from the data source, you can create an alias table named Time Day Grain.

You can use a physical table as a fact or a dimension depending on the context. Oracle recommends that you create multiple aliases of the same table to ensure that its configuration as a dimension and as a fact don't interfere with each other.

Alternatively, you can create multiple physical alias tables at the same time. See Create Multiple Physical Alias Tables.

You can change some of the source table properties that the alias table inherits, such as its source table and caching method. You can also use the alias table to create joins. See What Are a Physical Table's General Properties?

For information about designing alias tables, see Physical Table Alias.

  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 Physical Layer Physical layer icon.
  4. In the Physical Layer pane, browse to locate the table you want to create an alias table for, right-click it, and click Create Physical Table Alias.
  5. In Create Physical Table Alias, go to the Name field and enter a table name.
  6. Click OK.
  7. Optional: Locate the new alias table and double-click it to open it. Click General and update the table's properties such as its source, caching, and keys.
  8. Click Save.