OBIEE 10G/11G - Physical Alias

Bi Server Architecture With Client

About

Use physical aliases in the Physical layer with consistent naming conventions to:

  • order the physical tables
  • easily identify the data source in the business logical model.
  • to identify the tables that you use. If you want to delete them, you get this error:

Obiee Physical Alias Table Cannot Be Deleted

To have the name of a table to which you assigned an alias appear, make sure you turn on the following option in the Tools > Options > General menu path: Display original names for alias in diagrams.

  • Eliminate all physical joins that cross dimensions (inter-dimensional circular joins)
  • Eliminate all circular joins (intra-dimensional circular joins)





Discover More
Obiee Presentation Catalog Aliases
OBIEE 10G/11G - Alias (synonyms)

The BI Server offers two type of alias: presentation alias to rename a presentation table / Column physical alias to order and identify the sources When you rename in the presentation catalog...
Obiee 11g Inconsistency Check 39059
OBIEE 11G - [39059] Logical dimension table has a source at level that joins to a higher level fact source

This repository consistency check is a new check performed in 11G and indicates that a dimension joins: on the detail level but also on a higher level ... You can get this kind of data modelling...



Share this page:
Follow us:
Task Runner