OBIEE - Identifying a Dimension Table

Bi Server Architecture With Client


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. Dimension table attributes provide context to numeric data, such as, the numeric data (measure) “# of Service Requests”. Attributes stored in this example dimension are Service Request Owner, Area, Account, and so on.


In the two following figures below, Sales Facts and Facts are Fact tables while Markets, Periods, Products, Account Hierarchy, Account Region Hierarchy and Account are dimension tables. Any logical table that is not a fact table or a bridge table is a dimension table.

The figure below illustrates a true star schema:

Obiee True Star Schema

The next figure illustrates a logical snowflake schema which defines hierarchies by using multiple dimension tables. The value of the snowflake schema is that the server treats outer joins differently from outer joins that are within a logical table source. Within a logical table source, the joins are always executed. When between logical tables, the joins are only performed when required.

Obiee Snowflake Schema

Any logical table that is not a fact table or a bridge table is a dimension table.

Dimension tables are expected to store columns that cannot be aggregated whereas fact tables are expected to store columns that can be aggregated.

Discover More
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...
Obiee Dimension Drill Down Parameters
OBIEE 10G/11G - Level-based Hierarchy

Level-based hierarchy is the first type of hierarchy in OBIEE. Dimension hierarchy levels allow : to perform aggregate navigation, to configure level-based measure calculations, users from Dashboard...

Share this page:
Follow us:
Task Runner