O'Reilly logo

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial by Adrian Ward, Haroun Khan, Christian Screen

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

Business layer

In this layer, we are not limited by the constraints of the actual physical tables in the database. We can restructure and consolidate sources that will inform the BI server on how to best handle the end user requests. Most of the metadata, which affects SQL production by the BI server, is handled in this layer.

Business model

The business model is the highest level in this layer and contains a business view of the physical schema. You should be able to simplify the physical schema so that in the end you are looking at the business view of the data. Anything we do in this layer, will not affect the work that has been done in the physical layer, and we can create multiple models based on the same physical sources.

To create a business ...

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