Create Multiple Physical Alias Tables

Instead of creating alias tables one at a time, you can create alias tables for multiple physical tables at the same time.

An alias table uses a physical table as its source and provides an alternative name for that table. Creating aliases can help you use the same physical table in different roles in your semantic model.

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 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 use Crl+click or Shift+click to select the physical tables you want to create alias tables for. Right-click, and click Create Physical Table Alias.
5. Optional: To update a new alias table's properties, locate the alias table and double-click it to open it. Click General and update the table's properties such as its source, caching, and keys.
6. Click Save.