OBIEE 10G/11G - Alias (synonyms)

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

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 

Physical Table Alias


Powered by ComboStrap