OBIEE - Grain - Level of (summarization|aggregation)

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

1 - About

Grain definition in the context of OBIEE.

The following list describes the different grains in navigating a query:


3 - Type of Grain

3.1 - Query

The grain of the request (logical sql) is the level of summarization. The grain is determined through the baseline columns. In the query below, the query grain is Quarter.

SELECT quarter, myMetrics FROM MySubjectArea

In 11g, the hierarchical column determines the grain of the report.

Let op, the following under the hood query expression change also the query grain:

3.2 - Aggregation

The aggregation grain is defined in the content tab of the logical table source.

When the query grain match the aggregation grain of a logical table source, this one is used to create the physical query.

You can also define a aggregation grain calculation on a measure. This kind of calculation creates level-based measure.