O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required