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:
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 is data from a single domain that is split between multiple tables (multiple fragment).
The logical table sources have different columns:
The logical table sources have different rows (content):
One table source is a natural of compiled aggregate table from an other. It has then a different grain.
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.