OBIEE - Fact-based vertical partitioning/fragmentation

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

This technique allow you to :

It's also known as :

  • Fact-based partitioning
  • Fact partitioning outer join
  • Fact-based fragmentation

You implement it by creating in the Business Model Layer:

  • one logical fact table with two logical tables source for the same level of content
  • two logical fact tables joined with the same logical dimension (known as conforming Dimensions)

When minimum one measure of each logical fact table are included in the query, the BI Server generates two queries for each logical table source and perform a full outer join between them by the dimension columns.

The physical sql issued depends of some database parameters: OBIEE - How to control the use of the WITH CLAUSE and of STITCH Join ?

Advertising

3 - Reference