Transactional Business Intelligence uses Oracle BI EE for capturing the metadata and also as the end-user reporting and ad-hoc query tool. Its metadata source is view objects, Oracle ADF components that represent SQL queries. Built using Oracle Fusion Middleware , these view objects simplify access to data and abstract the underlying data model and business logic complexities. For more information, see View Objects Overview.
For information on how to embed Oracle BI objects in Oracle ADF applications, see “Oracle Fusion Middleware Developer's Guide for Oracle Business Intelligence Enterprise Edition”. It contains steps for adding content to Oracle ADF applications.
Wherever applicable, Transactional Business Intelligence and BI Applications use a common semantic model (single logical definition of the object in the Oracle BI EE Business Model and Mapping layer), which is a unifying factor that allows users to see the Oracle Fusion Applications data from either a transactional or a historical perspective. Most of the common dimensions and a few facts in the Business Model and Mapping layer of Oracle BI repository are shared between Transactional Business Intelligence and BI Applications.