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

Implementing Vertical Federation

Multidimensional sources store aggregated data, not the detailed data. Because of their nature, they just contain summary data at certain levels. These levels are specified during creation of the cubes.

Vertical Federation provides the ability to drill through aggregate multidimensional data into detail relational data.

We're going to use a different cube named Market to demonstrate Vertical Federation. As you've already learned how to import the multidimensional metadata and how to create a business model, these steps will be skipped in our example.

Here's the new source and new Business Model:

The new cube contains Dollars values that are aggregated at these levels:

  • Area dimension: District level
  • Time dimension:

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