OBIEE - Foreign Key or Physical Join

Bi Server Architecture With Client


A foreign key repository join is used only to define a Primary Key-Foreign Key Relationships in the Physical Layer.

It consist of a column or a set of columns and refers to the primary key column in another table.

When you create it in the physical diagram, you have to point first the dimension and then the fact table.

When you import keys in a physical schema, the primary key-foreign key joins are automatically defined.

If you want to define other relationship, you have to use a complex join.

Obiee Foreign Key Complex Join

You do not create joins for multidimensional data sources.

Documentation / Reference

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 - Defining the Logical Key of a Fact Table

If foreign key logical joins are used, the primary key of a logical fact table should then be comprised of the foreign keys. If the physical table does not have a primary key, the logical key for a fact...
Obiee Foreign Key Complex Join
OBIEE - Joins definitions in the repository (complex, foreign, logical table source)

You have three way to define joins when you model your repository: You can define: a Complex join a Foreign key a logical join property: From 11g, joins in the Physical and Business Model...
Obiee Foreign Key Complex Join
OBIEE 10G - Complex (Join|Operator) (Physical and Logical)

In 10g, A complex join is a metadata of sql join statement in the repository. In 11g, they doesn't exist anymore. In the business model, OBI recommends using complex logical joins instead of foreign...
Obiee Foreign Key Complex Join
OBIEE 10G/11G - Logical Join

A logical join is a join defined in the BMM layer. He is defined between a logical fact table and a logical dimension table. Two types of logical join exists: standard logical join logical foreign...

Share this page:
Follow us:
Task Runner