OBIEE - Grain - Level of (summarization|aggregation)

Bi Server Architecture With Client


Grain definition in the context of OBIEE.

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

Type of Grain


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:


Obiee Fragmentation Content One Column 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.

Obiee Logical Column Level Region

Discover More
Bi Server Architecture With Client
OBIEE - (Fragment|ation) (Partitioning)

The fragmentation (known also as partitioning) is the most powerful feature of OBIEE. You can fragment (or partition) any logical table (fact table as dimension table) in more than one logical table source...
Obiee Fragmentation Content One Column
OBIEE - Aggregate (Navigation|Table|Content)

The aggregate navigation capability of the Oracle BI Server allows queries to use the information stored in aggregate tables automatically. When users request information at a high “grain” of aggregation,...
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...
Oracle Olap Query
OBIEE - How to define OBIEE to leverage SQL OLAP Query ?

While not really different from any other implementation, it is useful to point out that it is very likely that cube views will contain measures such as rankings and percentages that should generally not...
Obiee 10g Logical Level Key
OBIEE - Logical level

The Logical level or level are the key level of the hierarchy and defines the grain of each table (logical table) (Fact as Dim) when set in the content tab. The level key: defines the unique...
Bi Server Architecture With Client
OBIEE - OBIS - (Universe|Domain)

A domain is the entire set of data for a level of aggregation. When a logical table is sourced from a set of fragments for a particular aggregation level. Within a whole universe, measure aggregations...
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...
Bi Server Architecture With Client
OBIEE - [39008] Logical dimension table does not join to any fact source

When you perform a consistent check, you can get this business model warning: This problem can occurs when a fact table (such as a stock table) is only valid for a defined aggregation grain. You then...
Obiee11g Time Dimension Property
OBIEE 10G/11G - How to set up the time dimension (for time series functions Ago, Todate, ) ?

Oracle BI Server ships Time Series Conversion Functions : AGO and TODATE. They are supported for all relational database and for use with Essbase. They are not support for flat files. To use them on...

Share this page:
Follow us:
Task Runner