Tag Archives: oracle business

BI Apps Architecture Overview

“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: , , , , , , , , , , , , , , , ,

Multi-Source Session Variables in OBIEE11g RPD – Get values from multiple sources

In addition to supporting regular session variables that are populated from one data source, In version, the Oracle Business Intelligence also supports session variables that can be populated from multiple data sources. These multi-source session variables can be used in logical queries or in repository data filters, and contain the union of values from the different data sources. There is no restriction on the number of values that the multi-source session variable can hold. To create a multi-source session variable, you first create row-wise initialization blocks for each source.

Then, you explicitly define session variables for each source. The format for the session variable names must be:

  • <ms_variable_name>____<source>

where the separator must be exactly four underscore characters.

This automatically creates a single multi-source session variable, named:

  • <ms_variable_name>

The component session variable names (<ms_variable_name>____<source>) appear separately in the Variable Manager in the Administration Tool, but the Expression Builder displays only the single multi-source session variable name (<ms_variable_name>).


While the main focus of this section is on the definition and usage of multi-source session variables, you may also select the VALUEOF the component session variables in logical queries and data filters.

If any of the row-wise initialization blocks returns null results, this is logged in the Oracle BI Server log, nqserver.log. Values can still be added to the multi-source session variable from other component initialization blocks that succeed in returning values. The multi-source session variable will fail only if all of the component initialization blocks return null values.

You can set execution precedence and deferred execution with multi-source session variables, similar to regular session variables.


Example to Illustrate the Creation and Usage of Multi-Source Session Variables

The following example illustrates how to create and use a multi-source session variable:

  1. In the Variable Manager in the Administration Tool, select Action > New > Session > Initialization Block.
  2. Create a row-wise initialization block called ‘Extra_products_orcl_init’ with the following SQL for Default initialization string:

               select distinct ‘MSVPRODUCTS____orcl’,PROD_NAME from extra_products

  1. Create a second row-wise initialization block called ‘SampleApp_Products_init’ with the following SQL for Default initialization string:

              select distinct ‘MSVPRODUCTS____OBI‘,”Sample App Lite Data”…”D10 Product”.”Prod_Dsc” AS “Prod_Dsc” from “Sample App Lite Data”…”D10 Product”

  1. Still in the Variable Manager, select Action > New > Session > Variable.
  2. Create a session variable called MSVPRODUCTS____orcl, making sure to include four underscores between the variable name and the source name. And select the initialization block called Extra_products_orcl_init.
  3. Create a second session variable called MSVPRODUCTS____OBI, making sure to include four underscores between the variable name and the source name. And select the initialization block called SampleApp_Products_init.

While the component session variables appear in the Variable Manager, the multi-source session variable that has been created, MSVPRODUCTS, will appear in Expression Builder.


Using the Multi-Source Session Variable in a Logical Query:

You can now use the multi-source session variable MSVPRODUCTS in a logical query.

For example:
Select “SampleApp Lite”.”D1 Products”.”Product Type”,”SampleApp Lite”.”D1 Products”.”Brand”,”SampleApp Lite”.”D1 Products”.”Product” from “SampleApp Lite”.”D1 Products” where “SampleApp Lite”.”D1 Products”.”Product”=VALUEOF(NQ_SESSION.MSVPRODUCTS)

Using the Multi-Source Session Variable in a Data Filter:

To use the multi-source session variable MSVPRODUCTS in a data filter, perform the following steps:

  1. In the Administration Tool, select Manage, then select Identity.
  2. In the Identity Manager dialog, in the tree pane, select BI Repository.
  3. In the right pane, select the Application Roles tab, then double-click the application role for which you want to set data filters.
  4. In the Application Role dialog, click Permissions.
  5. In the User/Application Role Permissions dialog, click the Data Filters tab.
  6. In the Data Filters tab, create the data filter expression:

             “SampleApp Lite”.”D1 Products”.”Product” = VALUEOF(NQ_SESSION.MSVPRODUCTS)


Note that the Expression Builder, as shown in the image that follows, displays only the multi-source session variable MSVPRODUCTS, and not the regular session variables that were used during the creation of the multi-source session variable.



Shiva Molabanti


Posted by on April 17, 2013 in BI Publisher, OBI EE, OBIEE 11g, Weblogic


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

OBIEE is available now

The Oracle Business Intelligence Enterprise Edition (OBIEE) has been made generally available.

The software is available for download from OTN.


The related documentation is published and available from Oracle Business Intelligence Enterprise Edition Documentation library.
With this release of OBIEE, the entire Business Intelligence Foundation Suite has been made generally available, opening the door for “Oracle Exalytics Super-fast, Super-ready”.

For more information on exalytics:

Oracle Exalytics installation,configuration and deployment info:

Happy Reporting….




Leave a comment

Posted by on March 3, 2012 in BI Publisher, OBI EE, OBIEE 11g


Tags: , , , , , , ,