OBIEE - Repository Aggregation rules based on dimension (dimension-specific aggregate)

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

1 - About

Obiee offer the possibility to have differents measure aggregation rule based on the dimension.

This functionality is really tied to the last and first function (in order to define its grain ?)

OBIEE - What means "Data is dense" ?

Advertising

3 - Example with the time dimension

Aggregation Rule Level Description
Last Year Amount for the last month
First Year/Quarter Amount for the first month
Average Year/Quarter Average of all child month

4 - Aggregate with Case Statement

The case function can be use in an aggregation based on dimension.