OBIEE 10G/11G - Logical Join

Bi Server Architecture With Client

About

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 key join

In the business model, OBI recommends using complex logical joins instead of foreign key logical joins.

When Complex joins are used in the business layer then they are really acting as placeholders. They allow the OBI Server to decide on which are the best joins between fact and dimension logical table source to satisfy the request.

The joins occurs between a fact logical table source and a dimension logical table source when they have the same aggregation grain.

Type Logical join

10G 11G
Obiee Foreign Key Complex Join Obiee Logical Join 11g

Standard

In 10g, the standard logical join are defined with the new complex join tool.

In 11g, you have only one choice.

Foreign key

In 10g, The Foreign key logical join are defined with the new foreign key join in the business model.

In 11g, this kind of join is deprecated and if you want to use them, you have to check the preference in the Tools/Options of the administration tool.

Obiee 11g Bi Server Options Logical Foreign Key





Discover More
Bi Server Architecture With Client
OBIEE - [39008] Logical dimension table does not join to any fact source

When you perform a consistent check, you can get this business model warning: This problem can occurs when a fact table (such as a stock table) is only valid for a defined aggregation grain. You then...
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