OBIEE - Baseline column

Bi Server Architecture With Client

What is a baseline column ?

Dimensional Data Modeling - Descriptif Attribute (Dimensional Attribute) 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.

Obiee Baseline Column

The BI Server don't see it as a measure and then add it of:

  • in the GROUP BY clause
  • of in a ROW_NUMBER function

in the physical sql generated in order to preserve (of augment) the grain of the logical SQL

Discover More
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...
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...
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 Fragmentation Content One Column
OBIEE - Grain - Level of (summarization|aggregation)

Grain definition in the context of OBIEE. The following list describes the different grains in navigating a query: Query grain. The grain of the request. Aggregation grain. The grain of the aggregate...
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...
Exp Builder Ago Td
OBIEE - Time Series Conversion Functions : AGO and TODATE

Time series functions in OBIEE. The implementation of the time serie function is based on the time dimension. ( See set up time dimensions) At query time, the Oracle BI Server then generates SQL that...
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