Creating level-based measures

A level-based measure is a column whose values are calculated to a specific level aggregation such as YearRevenue or StateRevenue. For example, if the business users want to calculate the total revenue for the GRAND TOTAL level of the Customer dimension, we're going to create a level-based measure, which will be mapped to GRAND TOTAL level of the Customer dimension and this will calculate total revenue across all regions.

In order to create the level-based measure, dimensions and hierarchies should be created before. Then we're going to create a new logical measure column and map it to a specific level.

How to do it...

  1. First step will be creation of a logical measure column. So we're going to right-click on the fact ...

Get Oracle Business Intelligence 11g R1 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.