BI Apps Architecture Overview

09 May

“Oracle Business Intelligence Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence throughout an organization. These solutions enable organizations to gain more insight and greater value from a range of data sources and applications including Oracle E Business Suite, PeopleSoft, JD Edwards, Siebel, and third party systems.”

Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive and market leading BI platform. This enables organizations to realize the value of a packaged BI application, such as rapid deployment, lower TCO, and built-in best practices, or to build custom BI applications—all on one common BI foundation.”

The new BI Applications has been completely re-architected to leverage the power of ODI with its E-L-T architecture, and has new Out of box tools to increase the productivity and lower down the TCO. The BI Apps has significantly expanded with new analytical contents.

The BI Apps components:

  • Source Systems: The Oracle or non-oracle OLTP systems that holds the data for ETL into the Oracle Business analytics warehouse. This data becomes the underlying data for your analyses and includes customer information, inventory, sales, marketing, accounts, and other types of data you collect about your business.
  • Oracle Business Intelligence Enterprise Edition: Oracle Business Intelligence Enterprise Edition (Oracle BI EE) is a business intelligence platform that is used to access and present data in easy-to-understand formats, such as tables, graphs and Scorecards/KPIs.
  • Oracle Business Analytics Warehouse: The Oracle Business Analytics Warehouse is a modular enterprise-wide data warehouse data model with conformed dimensions for data integrated from multiple sources. The Oracle Business Analytics Warehouse supports the analytical requirements of Oracle Business Intelligence Applications.
  • Oracle BI Applications Configuration Manager (BIACM) and Functional Setup Manager (FSM):  This is similar to DAC tool. But unlike DAC, The BIACM and FSM have great features and functionality in BI APPS to simplify the configurations process, minimize the manual steps and configurations, and to have a guided list of configurations steps and checklists.  That reduces the dependency on documentation….
    •  Oracle BI Applications Configuration Manager (BIACM):  The BIACM is a web based UI application for setting up and maintaining an Oracle Business Intelligence Applications environment. Oracle BI Applications Configuration Manager works in conjunction with Functional Setup Manager to provide guided Tasks to configure Offerings and Functional Areas.
    • Functional Setup Manager (FSM): The FSM is also a web based UI application which enables you to manage and perform functional configuration tasks and to deploy the Offering and Functional Areas that were selected. Functional Setup Manager generates a list of configuration tasks for the deployed areas, which you can assign to different functional developers and monitor the implementation status.
  • Oracle Data Integrator: Oracle BI Applications uses Oracle Data Integrator (ODI) as its data integration platform. Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services with its innovative E-LT Architecture.  

    E-LT is an innovative approach to extracting, loading and Transforming data. Typically ETL application vendors have relied on costly heavyweight; mid-tier server to perform the transformations required when moving large volumes of data around the enterprise. ODI delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs, even across heterogeneous systems by pushing the processing required down to the typically large and powerful database servers already in place within the enterprise. 

    In an Oracle BI Applications environment, ODI works in conjunction with Oracle BI Applications Configuration Manager, which provides a user interface for managing load plans as well as access to ODI Console, the web-based console that enables you to view objects in the ODI repository.

  • Oracle GoldenGate: Oracle GoldenGate is an optional product. Oracle GoldenGate is a data replication tool leveraged to create a replicated OLTP schema. This replicated OLTP schema is used as a Source- Dependent Schema during ETL.

A logical Overview of BI Apps


Oracle BI Applications use all of the components depicted in above figure to deliver information specific to your business needs. The source system (OLTP) data is loaded into the Business Analytics Warehouse Database (OLAP) and it is transformed using the ODI mappings that are stored in the BI Applications Repository Database. This database contains the repository information for BI Applications ODI repository and the BI Applications Components Repository.

Optionally, you can leverage Oracle GoldenGate to replicate your OLTPs data and then to do Source – Dependent load. This helps us to least dependent on the source system availability for ELT operations.



Shiva Molabanti


Posted by on May 9, 2013 in OBI EE, OBIEE 11g, Weblogic


Tags: , , , , , , , , , , , , , , , ,

10 responses to “BI Apps Architecture Overview

  1. Priyal

    May 10, 2013 at 6:32 am

    Hi Siva,
    I have two question on latest release of BI apps:
    1. ODI will be used as ETL integration platform for this BI apps, does that mean Informatica will not be used as integration platform for BI apps from this release onwards?
    2. If yes, how the upgrade will be managed from earlier Informatica BI apps repositories to ODI repositories?

    Priyal Chindarkar

  2. Saraswati

    May 29, 2013 at 5:05 pm

    Does BIACM work with Informatica as well or just ODI?

    • Shiva Molabanti

      June 5, 2013 at 4:12 am

      No its just for ODI starting from biapps


  3. Jill Lopez

    June 12, 2013 at 7:45 pm

    Hello Shiva

    I am trying to integrate hadoop with obiee and would appreciate if you have some tips.
    I have hadoop and hive on a VM on my windows laptop.
    I have built a rpd using the data in hive and that is succesfully.I can import hive data and update row count, view data etc.

    But problem occurs when I try to build a report.
    For this I have updated the odbc.ini and the opmn.xml file with the hive data driver and the datadriver 7.0.1 but no luck.

    I am using OBIEE:

    I would appreciate any help.

  4. Darren

    August 26, 2013 at 5:13 am

    I am truly delighted to glance at this blog posts
    which carries lots of useful data, thanks for providing these kinds of information.

  5. Chad

    October 20, 2013 at 1:50 pm

    We currently have Siebel CRM, Informatica/DAC for ETL and OBAW on Oracle and OBIEE for reporting. We are having discussions to move to Hadoop.

    – What are some key considerations to do this transition?
    – How would our current architecture change?
    – How would the OBAW data model have to be transitioned onto Hadoop hdfs?

    Just early stage discussion so not sure if my questions make very much sense at this point. Looking for some direction or a discussion…

    Thanks in advance,

  6. sadhana

    December 16, 2013 at 12:24 pm


    Could you please help us to get better understanding on how to add columns selector views in different columns within the same report in OBIEE platform?


  7. amir

    December 10, 2014 at 12:57 pm

    Our install for BI Apps is not behaving as expected. The “biacm” component works fine when connected directly through Node1 and Node2 of the HA cluster however it does not work through the load-balanced IP name and URL – the login page refreshes but does not allow access to configuration manager and returns to the credentials home login sceen and no error message is given We have no such issue when accessing “analytics” which uses the same URL and port (9704). We are not using dedicated web servers and only weblogic.

    Please could you advise on the appropriate log files to look at or provide input to assist in analyzing this issue?




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: