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 shared measures

Shared measure is a measure that is calculated by using a level-based measure. There's no difference when you compare it with other logical measures.

How to do it...

  1. We're going to create a new logical column in the fact table and again we're going to define a formula. In the formula, we're going to use a level-based measure as well. The formula I used in my demonstration is as follows. It's going to calculate the percentage of a month level sales amount with the total year level sales.
    (Sales.Fact_Sales.Dollars / Sales.Fact_Sales.Year Total Dollars ) * 100

    This time we're not going to change anything in the Levels tab. We're going to leave the settings as it is.

  2. As usual, the new logical column should be added to the Presentation ...

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