OBIEE - (Fragment|ation) (Partitioning)

Bi Server Architecture With Client

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

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.

Fragmented data

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

Type of fragmenation / partition

Fact-based / Dimension-based fragmentation

The logical table sources have different columns:

Content-based / Value-based fragmentation

The logical table sources have different rows (content):

Level-based fragmentation / aggregate navigation

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

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.

Documentation / Reference





Discover More
Obiee Essbase Unbalanced Hierarchy
OBIEE - Essbase

Cube scope: Member attributesunbalanced hierarchies“”“”hierarchy columnattribute column Support...
Bi Server Architecture With Client
OBIEE - Fact table (of logical fact table)

Dimension tables are expected to store columns that cannot be aggregated whereas fact tables are expected to store measure columns that can be aggregated. As a general rule: don’t include...
Bi Server Architecture With Client
OBIEE - Fact-based vertical partitioning/fragmentation

This technique allow you to : mix two facts table with two different grains (the level based partitioning) perform a densification (to preserve dimension value) : partition vertically your fact...
Bi Server Architecture With Client
OBIEE - Fragment

A fragment is just an other name for a logical table source in the context of fragmentation. For instance, you splits a table in two child tables (History and current). In OBIEE, the original table...
Bi Server Architecture With Client
OBIEE - OBIS - (Universe|Domain)

A domain is the entire set of data for a level of aggregation. When a logical table is sourced from a set of fragments for a particular aggregation level. Within a whole universe, measure aggregations...
Bi Server Architecture
OBIEE - Query Compiler

The query compiler is responsible of the compilation of a logical sql in the query processing process of BI Server. The query compilation is composed of the following five phases: parsing, , navigation,...
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