OBIEE - the Cross/Cartesian Join

Obiee Ceim


To perform a cross join (often between the dimension), you have two ways :

To know what sort of join is is a cross join, follow this link : SQL - Cross Join / Cartesian Product / Cross Product

In the repository

As the cross join is mainly used to densify the data, you can find the design details in this paragraph from this article.

With the Obiee Logical Sql

In an answers advanced tab, you can set directly a Sql statement.

Example of cross join with Obiee logical sql :

SELECT  C.saw_0 saw_0, B.saw_0 saw_1, B.saw_1 saw_2  FROM 
 ( Select Calendar."Calendar Year" saw_0, Fiscal."Fiscal Week Number" saw_1 FROM SH ) B,
( Select Products."Prod Name" saw_0 FROM SH ) C

Discover More
Obiee Ceim
OBIEE - Logical Sql

The logical SQL is the SQL that understand BI Server. It's a full Ansi 92 SQL (including subqueries and derived tables), plus special functions (SQL extensions) like AGO, TODATE, EVALUATE, and others....

Share this page:
Follow us:
Task Runner