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

Bi Server Architecture With Client

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




Discover More
Obiee Ceim
OBIEE - Last/First function (Point in Time measure)

Function that selects the first/last returned value of the expression argument. Syntax: where expression is any expression. You cannot use it in Logical SQL statements. It must be used in the repository....
Obiee Measure Column
OBIEE 10G/11G - Measures (Columns|Attributes)

A measure column is a logical column with an aggregate function. Any column with an aggregation rule is a measure. Examples include Revenue or Units Sold. Measures need to be defined in a logical fact....



Share this page:
Follow us:
Task Runner