Aliases are references to existing tables in a schema. An Alias is a table that is an exact duplicate of the original table (base table), with a different name.
Why using alias ?
You use aliases for two main reasons:
- To use the table more than once in a query.
- To abbreviate the table name to save typing when writing freehand SQL.
The example Beach universe contains 2 aliases; Resort_Country for Country, and Sponsor for Customer.
- Select the table in Business Object - Universe Designer
- Menu > Insert > Alias
- Click an alias and select Edit > Clear.
- Menu > Tools > List of Aliases
To avoid confusing base tables with aliases, you can display the alias with the name of the base table it represents in the table title as follows: Select Tools > Options > Graphics, and then select the Aliased Name check box