OBIEE 10G/11G - Alias (synonyms)

Obi Edition

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

Obiee Presentation Catalog Aliases

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

OBIEE 10G/11G - Physical Alias





Discover More
Bi Server Architecture With Client
OBIEE - Physical Layer

The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information the physical data sources. The most common way to...
Bi Server Architecture With Client
OBIEE 10G/11G - Presentation Layer

This is the layer of the logical business model that is accessible for the clients through a structured query language (SQL) better known as the logical sql. Presentation layer is often describe as the...



Share this page:
Follow us:
Task Runner