OBIEE - Joins definitions in the repository (complex, foreign, logical table source)

Bi Server Architecture With Client

About

You have three way to define joins when you model your repository:

Obiee Foreign Key Complex Join

You can define:

Obiee Join Lts

From 11g, joins in the Physical and Business Model Diagrams are now represented by a line with an arrow at the “one” end of the join, rather than the line with crow’s feet at the “many” end of the join that was used in previous releases. When creating joins in the Physical and Business Model Diagrams, you now select the “many” end of the join first, and then select the “one” end of the join. In previous releases, joins in the diagrams were created by selecting the “one” end of the join first.





Discover More
Obiee Fact Cross Join
OBIEE - Densification with the fact-based fragmentation capabilities

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. The preservation of the dimensions is is also well known...
Obiee Foreign Key Complex Join
OBIEE - Foreign Key or Physical Join

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...
Bi Server Architecture With Client
OBIEE - Join

This article talk the SQL joins in OBIEE. You have two ways to define a join in OBIEE: in the repository when you model : in a logical sql statement OBIEE can perform internal join in its...
Bi Server Architecture With Client
OBIEE - Repository Design

... .. A consideration to take when designing a subject area is to pay attention at the final user. Do you design for a user:OBIEE Analytics/Reporting...
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...



Share this page:
Follow us:
Task Runner