OBIEE - (Fragment|ation) (Partitioning)

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

1 - About

The fragmentation (known also as partitioning) is the most powerful feature of OBIEE. You can fragment (or partition) any logical table (fact table as dimension table) in more than one logical table source (LTS).

For the same logical table, you may have more than one logical table source (or physical table as one logical table source is always mapped to only one physical table).

You have three sort of fragmentation:

  • Fact-based / Dimension-based fragmentation
  • Content-based / Value-based fragmentation
  • Level-based fragmentation / aggregate navigation
Advertising

3 - Fragment

A fragment is a logical table source that does not contain the entire set of data at a given level.

The type data that the fragment does contain must be set.

4 - Fragmented data

Fragmented data is data from a single domain that is split between multiple tables (multiple fragment).

5 - Type of fragmenation / partition

5.1 - Fact-based / Dimension-based fragmentation

5.2 - Content-based / Value-based fragmentation

The logical table sources have different rows (content):

5.3 - Level-based fragmentation / aggregate navigation

One table source is a natural of compiled aggregate table from an other. It has then a different grain.

Advertising

5.4 - Complex

You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.

6 - Documentation / Reference