OBIEE - How to create a measure from data that is stored in a dimension table

Bi Server Architecture With Client

OBIEE - How to create a measure from data that is stored in a dimension table

About

You may:

  • need to create some count aggregation on your dimension attribute.
  • have some column in your dimension that hold measures such as the working day for a time dimension.

In this case, we are in presence of a level-based measure with all the logical level of the other dimensions set to the grand total level. Ie the aggregation takes place only for the dimension (group by one attribute of the dimension).

Steps

To define an aggregated measure of a dimension table, complete the following steps:

  1. Create a new fact logical table with the physical dimension table as source.
  2. Include all fields that should be aggregated as a measure of this new fact object.
  3. Add an aggregation rule to the column
  4. set the logical level of the other dimensions to the grand total level.

Below, a sum aggregation rule :

Obiee Measures Aggregation

Support

nQSError: 14026 - Unable to navigate requested expression

If aggregated calculations are performed directly from a dimension logical table field, an error similar to the following will appear:

A general error has occurred. [nQSError:  14026] Unable to navigate requested expression:  <Measure detail>). 
Please fix the metadata consistency warnings.

To resolve this type of error, put the measure indicated by the error message in a fact table object.





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