OBIEE 10G/11G - Alias (synonyms)

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

1 - About

The BI Server offers two type of alias:

  • presentation alias to rename a presentation table / Column
  • physical alias to order and identify the sources
Advertising

3 - presentation alias

When you rename in the presentation catalog a table or a column, the admin tool automatically create an alias that you can see in its property (Double click on it). This prevents reports that reference the original element from failing.

Example

With the above example, the below logical SQL

  SELECT "Fact".AMOUNT_SALES saw_0 FROM "SH" ORDER BY saw_0

is equivalent to this one.

  SELECT "Fact".AMOUNT_SALES saw_0 FROM "SH New Name" ORDER BY saw_0 

4 - Physical Table Alias