Oracle Business Intelligence Application (OBIA)

Oracle BI Applications is a business intelligence application which is a prebuilt solution.

Oracle BI Applications supports:

• Oracle sources, such as:
  • Oracle E-Business Suite Applications,
  • Oracle's Siebel Applications,
  • Oracle's PeopleSoft Applications,
  • Oracle's JD Edwards Applications,
• And non-Oracle sources, such as SAP Applications with the universal adpator.

Oracle BI Applications also provides complete support for enterprise data, including:

• financial,
• supply chain,
• workforce,
• and procurement and spend sources.

• OBIA - Naming Convention
• OBIA - Architecture with Informatica Powercenter and DAC
• OBIA - Installation
• OBIA - Universal Adaptor
• OBIA - Customization of the Oracle Business Analytics Warehouse
• OBIA - Log

• Oracle Procurement and Spend Analytics
• Oracle Financial Analytics
• Oracle Supply Chain and Order Management Analytics
• Oracle Human Resources Analytics
• Oracle Sales Analytics
• Oracle Contact Center Telephony Analytics
• Oracle Price Analytics
• Oracle Service Analytics
• Oracle Marketing Analytics
• Oracle Loyalty Analytics
• Oracle Pharma Analytics
• Oracle Project Analytics

Oracle Business Intelligence Application (OBIA) is composed of :

• an Data Integration tool:
  • Informatica powercenter and dac
  • of Oracle Data Integrator (Sunopsis)

This is the third-party application that performs the extract, transform, and load (ETL) operations for the data warehouse.

• and as data access tool obiee which provides prebuilt reports and dashboard content

• Oracle® Business Intelligence Applications Content Guide Release 7.9.6,7.9.6.1
• Oracle® Business Intelligence Applications Metrics Reference Guide Release 7.9.6
• Oracle® Business Intelligence Applications ETL Data Lineage Guide Release 7.9.6,7.9.6.1

The data model reference contains the following major topics:

• Naming conventions
• Domain values
• Star schema diagrams
• Table and column descriptions

Documentation:

• Oracle Business Analytics Warehouse Data Model Reference Version 7.9.6
• All Oracle Business Analytics Warehouse Data Model Reference on My Oracle Support

• SDE: Source Dependent Extract
• SIL: Source Independent Load
• PLP: Post-Load Process