KPI Partners Blog

Using Level-Based Measures in OBIEE

Posted by KPI Partners News Team on Mon, Oct 27, 2014 @ 10:15 AM

by Naresh Meda

What Is A Level-Based Measure?

A level-based measure is a column whose values are always calculated to a specific level of aggregation. Here is an example of a level-based measure using a Products and Revenue table.  A level-based hierarchy is created for Products as follows:
                                        describe the image                   
By default, when we drill down within the products hierarchy from Brand level to Product level, the corresponding Revenue drills down to Product level.

Level-Based Measures in Oracle Business Intelligence (OBIEE)

If we want to view the revenue aggregated to the Brand level then:

  • We create another measure called 'Brand Revenue' which is a duplicate of 'Revenue' in the repository (RPD).
  • Click on its properties and in the 'Levels' tab specify the logical level as 'Product Brand' for Logical Dimension 'H2 Product'.  Save the RPD.

Level Based Measures in OBIEE & Tableau   Naresh  Medha 2 resized 600

  • When Brand Revenue is dragged into our analysis, it shows Revenue for Brand level, no matter how far we drill down from the Brand level.

Level Based Measures in OBIEE & Tableau   Naresh  Medha 3 resized 600


Naresh Meda

Naresh Meda is Lead Consultant at KPI Partners.  He has specialized in the area of Business Intelligence, Data Warehousing, and Data Integration. Check out Naresh's blog at


Tags: OBIEE, Data Discovery, Business Intelligence, Tutorial, Naresh Meda, Oracle BI, Blog

Subscribe to the KPI Blog