OBIEE 10G/11G - Measures (Columns|Attributes)

Bi Server Architecture With Client

About

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.

OBIEE offers two levels of measures calculation in the repository:

When the logical column has no aggregation rule, it's called a baseline column.

What is a measure column ?

A measure column is a column unlike the baseline column that has an aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.

Measure columns always calculate the aggregation with which they are defined.

Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.

Aggregation rule

Default

A default aggregation rule is defined for all dimensions.

Obiee Measure Column

Based on dimensions

For example, bank balances might be averaged over time but summed over the individual accounts.

Calculation Levels

OBIEE offers two calculation levels in the repository:

  • logical
  • physical

You can also define logical calculations in either of the following ways:

  • Before the aggregation, in the logical table source.
  • After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)

You can also define post-aggregation calculations in the logical SQL queries (Analytics, Answers, …)

Logical

Obiee10g Measure Logical Calculation

Physical

Obiee10g Measure Physical Calculation

Guidelines

The following are two general guidelines:

Note however, that non-aggregated columns can exist in a logical fact table if they are mapped to a source which is at the lowest level of aggregation for all other dimensions.

If the physical model stores non-aggregated fields or if there is a need to aggregate dimension table fields, the business model should be designed in a way that follows the above two guidelines.

Support

[38083] The Attribute xxxx defines a measure using an obsolete method.

Since version 10.1.3.2, Aggregate functions in logical column definitions which use other logical columns, e.g. SUM(Facts.Sales), are not supported anymore.

The supported method is to use the aggregation properties of a logical column which has a physical mapping.

You can change this behaviour by setting the parameter SUPPORT_OBSOLETE_MEASURES to YES in the NQSConfig.ini configuration file.

Documentation / Reference





Discover More
Obiee 10g Aggregation Rule
OBIEE - 10G/11G - OBIPS - Aggregation Rule

Aggregation rule. The aggregation rules apply to all aggregate function used in SQL statements : The 'aggregation rule' setting in Answer is applied to sub-totals and grand totals within the Answers...
Obiee Aggregate Sum Sum Formula
OBIEE - Aggregation rules in Logical SQL with the GROUP BY and BY clause

This section outlines the rules that the BI Server follows with respect to whether or not a logical query contains a GROUP BY clause and, if a GROUP BY clause is specified, what results you should expect...
Obiee Baseline Column
OBIEE - Baseline column

in OBIEE. A baseline column is a column unlike the measure column that has no aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository. The BI Server don't see...
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 table (of logical fact table)

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: don’t include...
Obiee Pivot Varchar Max
OBIEE - How to pivot a character column ?

The pivot of a character is just an easy way to split one character column in two or more columns. By default, the pivot view take the measures (the column set with an aggregation rule) and place them...
Star Schema
OBIEE - Identifying a Fact Table

A fact table is a table with measures. Measures need to be defined in a logical fact; any column with an aggregation rule is a measure. Oracle BI Server understands that any table in a repository that...
Obiee Integer Format Wide Default
OBIEE - Integer Datatype

In OBIEE, the integer datatype: follows the rule of an integer division (without the decimal part) is mandatory for some OBIEE intern use such as the LOGLEVEL variable or the indexcol function ...
Obiee Nested Aggregate Case When Formula
OBIEE - Nested aggregate measure

This article talk nested aggregate measure in OBIEE and try to found the best way to implement it. Before continuing, we have to answer to this simple question : what is a nested aggregated measure...
Obiee Pivot Measures
OBIEE - Pivot Measures (The Filter Function)

Indicator, description of Measures are generally the sign that you need to pivot your measure (i.e. to create a Pivot Measure) The revenue is booked. Revenue is the measure and booked is a description...



Share this page:
Follow us:
Task Runner