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

Articles Related

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

  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at del.icio.us
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Digg
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Ask
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Google
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at StumbleUpon
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Technorati
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Live Bookmarks
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Yahoo! Myweb
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Facebook
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Yahoo! Bookmarks
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at Twitter
  • Bookmark "OBIEE 10G/11G  -  Alias (synonyms)" at myAOL
 
dat/obiee/alias.txt · Last modified: 2011/09/09 15:29 by gerardnico