OBIEE - Defining a Non-Aggregated Measure (Baseline column) of a Fact Table

Bi Server Architecture With Client

Guidelines

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:

  1. Determine if there is a dimension logical table on which these fields can be added.
  2. If there is an existing dimension, add a new table source that maps to the fact table and then map the fields.
  3. If there is no adequate logical table, complete the following steps:
    1. Create a new logical table.
    2. Create a table source that maps to the fact table.
    3. Create a dimension hierarchy for this new logical table.
    4. In the business model diagram, create a complex join between the dimension logical table and the fact logical table. Also create a complex join to any other fact logical table mapped to the same physical table.





Discover More
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...
Obiee Measure Column
OBIEE 10G/11G - Measures (Columns|Attributes)

A measure column is a logical column with an aggregate function. Any column with an aggregation rule is a measure. Examples include Revenue or Units Sold. Measures need to be defined in a logical fact....



Share this page:
Follow us:
Task Runner