OBIEE - Baseline column

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - What is a baseline column ?

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 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

Advertising