OBIEE - Fact table (of logical fact table)

Bi Server Architecture With Client


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:

  • Typically, logical fact tables should not contain any keys. The only exception is when you need to send Logical SQL queries against the Oracle BI Server from a client that requires keys. In this case, you need to expose those keys in both the logical fact tables, and in the Presentation layer.
  • Normally, all columns in logical fact tables are aggregated measures, except for keys required by external clients, or dummy columns used as a divider. Other non-aggregated columns should instead exist in a logical dimension table.

Unlike relational fact tables, logical fact tables can contain measures of different grains. Because of this, grain is not a reason to split up logical fact tables.

Aggregate sources should be created as separate logical table sources. For fact aggregates, use the Content tab of the Logical Table Source dialog to assign the correct logical level to each dimension.

Fact sources are selected on a combination of the fields selected as well as the levels in the dimensions to which they map.

Fact Table Fragmentation

OBIEE - (Fragment|ation) (Partitioning):

Types of fact tables

The following is a list of the types of fact tables that OBIEE recognizes when using the project feature:

  • Simple (base) fact table. Fact tables with nonderived columns or with columns that are derived but whose expressions are made up of constants.
  • Compound fact table. Fact tables with derived columns whose components come from other fact tables
  • Component fact table. Simple (base) fact tables that are part of a compound fact table. Their nonderived columns are used in the compound fact table.

Documentation / Reference

Recommended Pages
Bi Server Architecture With Client
OBIEE - (Fragment|ation) (Partitioning)

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...
Obiee Fragmentation Content One Column
OBIEE - Aggregate (Navigation|Table|Content)

The aggregate navigation capability of the Oracle BI Server allows queries to use the information stored in aggregate tables automatically. When users request information at a high “grain” of aggregation,...
Obiee Aggregate Lts
OBIEE - Aggregate Navigation with level-based fragmentation

OBI Server features have the ability to retrieve queries from an aggregate table defined through level of the hierarchy instead of the fact table. This ability is a part of the aggregate navigation feature....
Bi Server Architecture With Client
OBIEE - Defining a Non-Aggregated Measure (Baseline column) of a Fact Table

If requirements exist to use fields without aggregation on a fact table, the fields should be defined in a dimension logical table using the following guidelines: Determine if there is a dimension logical...
Obiee Fact Cross Join
OBIEE - Densification with the fact-based fragmentation capabilities

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. The preservation of the dimensions is is also well known...
Bi Server Architecture With Client
OBIEE - Dimension (Logical Table)

A dimension logical table is typically joined to a fact logical table that will contain measures. Every logical dimension table should have a dimensional hierarchy associated with it. This rule holds...
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...
Obiee True Star Schema
OBIEE - Identifying a Dimension Table

Dimension tables contain attributes that describe business entities. For example, Customer Name, Region, Address, Country and so on. Dimension tables also contain primary keys that identify each member....
Obiee Repository Project Menu
OBIEE - Projects

A project consists of a discretely-defined subset of the metadata. Projects can consist of Presentation layer catalogs (subject areas) and their associated business model logical facts, dimensions, groups,...
Bi Server Architecture With Client
OBIEE - Repository Design

... .. A consideration to take when designing a subject area is to pay attention at the final user. Do you design for a user:OBIEE Analytics/Reporting...

Share this page:
Follow us:
Task Runner