OBIEE - Repository Aggregation rules based on dimension (dimension-specific aggregate)
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 ?
Articles Related
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.
