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

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

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 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 Alias.
  5. In Create Physical Table Alias, go to the Name field and enter a table name. Then go to Source and browse for and select the source table you want the alias table to use.
  6. Click OK.
  7. In the new alias table, click General and updated the table's properties.
  8. Click Save.