Monday, November 22, 2010

Oracle Business Intelligence Applications Architecture

Here i am providing brief information about OBI Apps Architecture.. 


The architecture contains four logical layers as shown below in Figure:



BI Presentation Services (Web Catalog)
BI Presentation Services include pre-built metrics, analytic workflows, reports, dashboards and alerts used to deliver information, stored in the Business Analytics Data Warehouse, to information consumers. These services are built on the Oracle Business Intelligence Enterprise Edition delivery platform, which is designed to meet the requirements of an enterprise business intelligence solution. Pre-built reports and dashboards are built on industry best practices, and provide rich content covering functional areas including sales, service, marketing, finance, supply chain, order management, procurement and human resources.

Pre-built Metadata (BI Server Repository)
The metadata layer includes the definition of role based views, dimensions, metrics, hierarchies, calculations, aggregation rules, canonical time dimensions, time series metrics, roles and security. The metadata layer is built on the Oracle Business Intelligence Enterprise Edition platform using the Admin Tool, a core component of the BI server, which is designed to meet the requirements of the Common Information Model to deliver consistent and integrated information to business users, by capturing the data from multiple source systems.

Business Analytics Data Warehouse
The Business Analytics Data Warehouse is the persistent layer where information is stored for retrieval when required. The data warehouse resides in a relational database platform like  oracle, IBM DB2, Teradata or Microsoft SQL Server. It consists of transaction grain tables used to capture facts from the key business processes across the entire value chain of an organization. Current snapshots and periodic snapshots are provided for supporting complex analysis needs and aggregate tables are built for faster retrieval. Hundreds of dimension tables conformed across all the fact tables contribute to enrich the analyses.

Data Integration Components (ETL/E-LT)
Data Integration components are used to integrate data from various operational systems such as E-Business Suite, PeopleSoft Enterprise, Oracle's Siebel CRM Applications and third party systems like SAP R/3 Applications, and load the information in the Business Analytics Data Warehouse. The data integration components are built using either the Informatica Power Center data integration platform or Oracle Data Integrator. Oracle Data Integrator delivers unique next-generation Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs, even across heterogeneous  systems.


No comments:

Post a Comment