Oracle Business Intelligence Enterprise Edition 12c - Second Edition
by Adrian Ward, Bill Anderson, Haroun Khan
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 that 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 it contains a business view of the physical schema. You should be able to simplify the physical schema so that in the end you get to look 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, but we can create multiple models based on the same physical sources.To create a business ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access