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 Horizontal Federation

As we discussed in the beginning of this chapter, OLAP cubes store precomputed summary data. Business users may need to compare the values that are stored in the cubes with the values from the relational databases. Combining the result sets from two different data sources can solve this business challenge.

Horizontal Federation allows us to generate a result set that is retrieved from both multidimensional and relational data sources. We'll have to make some modifications in the Business Model in order to implement Horizontal Federation.

In our scenario, projected values will be retrieved from multidimensional sources. The Forecast Dollars column will be the example. And we're going to use the Dollars column from ...

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