Table of Contents

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 Data Is Dense

OBIEE - What means Data is dense ?

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

Aggregate with Case Statement

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

Obiee Aggregate With Case