Oracle Business intelligence enterprise (OBIEE) is a comprehensive business intelligence platform that delivers a full range of capabilities including:
-Interactive dashboards
-Ad hoc queries
-Enterprise and Financial reporting
-Notifications and alerts
-Scorecard and Strategy management.
OBIEE Architecture:
Web logic Server: Managing and monitoring Java components
Enterprise Manager: Managing and Monitoring System components
OPMN: Oracle Process Manager and Notification for managing and monitoring system components
Oracle BI Admin Tool: Managing metadata repository
A Three layer data model file which represents
- Presentation: The data visible to the end user
- Mapping: The layer were data is transformed
- Physical: The physical data source
Oracle e-Business (EBS):
You need to define the link from to Oracle EBS to Oracle BI. This functionality hasn’t changed and Combined with the ‘FND: Oracle Business Intelligence Suite EE base URL’-profile option in Oracle eBS, you now are ready to navigate from Oracle eBS to Oracle BI.
Once The setup for Integrating Oracle eBS and OBIEE is complete. We can create links between the two. These links should make it possible to navigate from Oracle eBS to OBIEE and vice versa
Oracle EBS - OBIEE:
To embed a link in Oracle E-Business Suite that opens Oracle Business Intelligence dashboards, you need to create a form function and then assign menus and responsibilities.
Before you begin, log in to Oracle E-Business Suite as the system administrator . Then, select the System Administrator responsibility from the responsibility navigator pane on the left. The available menus appear on the right.
Follow the steps in this section to create the following objects, in sequence:
- Function
- Menu
- Responsibility
- User
- Profile
Assign responsibility to User and assign Profile at site level - FND: Oracle Business Intelligence Suite EE base URL
On the resulting screen, specify the Oracle Business Intelligence URL. For example:
http://my_server.domain.com:port
example at site level : http://fa5099-obiee.oracleads.com:8080
Run the below script to check if these setups are complete or update the script as per your requirement.
SELECT fa.application_short_name
, fa.application_name
, fda.application_short_name data_application_short_name
, fda.application_name data_application_name
, fdg.data_group_name
, frt.responsibility_key
, frt.responsibility_name
, frt.description responsibility_description
, fff.function_name
, fff.description function_description
, fff.user_function_name
, fm.menu_name
, fm.user_menu_name
, fm.description menu_description
FROM apps.fnd_menus_vl fm
, apps.fnd_form_functions_vl fff
, apps.fnd_menu_entries_vl fme
, apps.fnd_responsibility_vl frt
, apps.fnd_application_vl fa
, apps.fnd_application_vl fda
, applsys.fnd_data_groups fdg
WHERE fm.menu_id = fme.menu_id
AND frt.menu_id(+) = fm.menu_id
AND frt.responsibility_key LIKE '%OBIEE%'
AND fme.function_id(+) = fff.function_id
AND fa.application_id = frt.application_id
AND fda.application_id = frt.data_group_application_id
AND fdg.data_group_id = frt.data_group_id
ORDER BY frt.responsibility_key;
---------------------------------
SELECT fff.function_name
, fff.user_function_name
, fff.description
, fff.type function_type_code
, fft.meaning function_type
, fff.web_host_name
, fff.web_html_call
FROM apps.fnd_form_functions_vl fff
, fnd_lookups fft
WHERE fft.lookup_code = fff.type
AND fff.function_name like '%OBIEE%F'
AND fft.lookup_type = 'FORM_FUNCTION_TYPE';
Oracle Business Intelligence Applications (11.1.1.8.1/11.1.1.9.1) is a suite of pre built business intelligence solutions that deliver role-based intelligence. Oracle BI Applications support pre built aggregation and analysis of information from a variety of transactional applications, including Oracle E-Business Suite, Oracle Siebel, PeopleSoft, JD Edwards Enterprise One, as well as non-Oracle applications like SAP etc . These transactional applications are referred to source systems, because they provide the underlying data that source analyses
OBIA is a pre-build solution that includes hundreds of standard reports, metrics and dash boards as well as a rich and broad foundation of meta data that can be used to easily create custom reports and dash boards.
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.
it is Pre Built solution for variety of ERP Applications Financials, SCM, CRM, HRMS , it is built on suit of tools which involves ETL, ELT and primary based on oracle BI Enterprise edition reporting tool set, it contains a prebuilt warehouse. Oracle BI apps pulls data from ERP Systems onto prebuilt dashboards and reports for financials it comes with 16 pre built components and meta data for reporting purpose. it also contains prebuilt ETL to extract data from various sources like ERP.
BI solution is pre built & it means:
- A pre built data warehouse schema, the Oracle Business Analytics Warehouse, with associated extract, transform, and load (ETL) metadata and data-movement infrastructure to support aggregation and transformation for the analysis of data from all transactional sources
- A pre-built Oracle BI Applications metadata repository to support analysis of the data in the Oracle Business Analytics Warehouse.
- A suite of metrics pertaining to how organizations measure performance that your company can select from and apply to your particular line of business.
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.
Oracle Business Intelligence Applications includes the following:
Oracle Financial Analytics
Oracle Human Resources Analytics
Oracle Procurement and Spend Analytics
Oracle Project Analytics
Oracle Supply Chain and Order Management Analytics
Oracle Sales Analytics
Oracle Service Analytics
Oracle Marketing Analytics
Oracle Contact Center Telephony Analytics
Oracle Loyalty Analytics
Oracle Price Analytics
Oracle data integrator as an integration platform
- Pre-built warehouse
- Pre-built ETL
- Pre-built Meta data
- Oracle Business analytic Warehouse
Components of OBIA:
- Setup Tier: BI Configuration Manager, Functional Setup Manager.
- Data load Tier: ODI Agent, ODI Console, Load Plan Generators, Configuration Manager
- Reporting Tier: OBIEE Agent
Repositories: BA Warehouse, BI Application Components Repository, ODI repository
Files: BI Application RPD, BI Application presentation Catalog, Configuration Files.
OBIA- Finance Analytics:
- Oracle Business Intelligence Applications Configuration Manager
- Perform Functional Configurations (Functional setup manager)
- Implementations
- Configure Offerings
- Implementation Projects tab
- Create Implementation Project
- Enter Basic Information
- check some modules
- save and open projects
New Data Lineage Tool allows customers and implementers to track lineage from source to target - improving information transparency across their enterprise
Configuration Management expands System Setup and Load Plan definition capabilities, including the registration of multiple instances for the same Product Line Version, UI enhancements to support DW connection configuration and Load Plan definition, and Load Plan definition migration
The different components of OBIA 11.1.1.8.1 are
- Admin console
- BIACM(Business Intelligence Applications Configuration Manager)
- FSM(Functional Setup Manager)
- ODI Console(Oracle Data Integrator Console)
- RPD(Repository)
- Catalog
OBIA Configuration Manager:
Click Define Business Intelligence Application Instance where you define source and target systems and configure all your modules in Financials System Manager (FSM).
Sign into to Financial Setup Manager application.
The FSM helps you in creating all the configuration and all your application specific domain data loads.
Click Configure Offering link in the left side you get the list of offering and click the check box enable for Implementation.
Create a Load Plan: it helps to configure and create new load plan and it is used for generating the data and metadata to get dash board in the catalog link of the OBIEE.
In order to register an enterprise application it must exist in the environment and you must have access to the WLS Administrator security role as well as one of the other following roles:
- Application Implementation Administrator
- Application Implementation Consultant
- Application Administrator
- Application Developer
The steps required to integrate Oracle BI Applications with Oracle E-Business Suite Applications in the following ways:
- Single Sign-On first into Oracle E-Business Suite and have that authentication passed through to OBIEE
- Embed links to OBIEE dashboard/catalog in Oracle E-Business Suite pages
- Create Action Links within Oracle BI EE reports and dashboards that take you back into Oracle E-Business Suite in context
- Setup is required both on the E-Business Suite Application and OBIEE sides to perform this integration. These steps are detailed in this bulletin with an example of how to achieve this in the Oracle BI Applications. This document does not describe the mechanism to embed OBIEE charts, dashboards, or reports in the E-Business Suite application.
The different components that are responsible for the display of meaningful data on your dashboards. Functional configurations is an important task at each and every stage of BI implementation since accurate configurations and mappings translate to accurate data on dashboards.
These steps need input from the subject matter experts (SMEs)/ super users of your transactional source system to get the data right and when the technical folks show the BIACM and FSM UIs to functional SMEs for their input, the questions they would be asked are:
- This UI does not make sense.
- What is all that Mapping about?
- Why you need that input?
The answer that would help:
These functional setups, based on either business requirements or on transactional source system settings or configurations, direct the manner in which relevant data is moved and transformed from source database to target database.
Functional setups are also called functional configurations which provides accurate and successful movement of data from (source system) EBS to (database to target Business Analytics Warehouse) Dashboard and they Control the manner in which data is displayed.
The implementation phases for Oracle BI Applications. A typical product lifecycle consists of the following process, some of which may happen concurrently.
- Installation
- OBIA architecture and components
- Configurations
- Data Load-Domain Load/Data Load/Incremental Load/Issues in Data Load
- Customization to RPD
- Customization to Dashboards
- Migration
The Database layer has
- Source System
- OBAW
- Business Analytics Warehouse
- Business Intelligence Applications Components Repository
- Business Intelligence Applications I/O Schema
- Oracle Data Integrator Repository for BI Applications
Components Deployed into Manager Server "bi_server1"
- Oracle BI Applications Configuration Manager
- Functional set up manager
- Load plan generator
- ATG Lite
Components deployed into Managed serer “Odi_Server1” are
- ODI Console
- ODI agent
- Client tier
- Console accessed through Web browsers.
- ODI Studio is installed on a developer client machine. For BI Applications usage, ODI SDK must be installed along with ODI Studio.
Reference: support.oracle.com, OBIA/OBIEE user guide and implementation guide and note#555254.1, 1343143.1, 749190.1, 758392.1, 755768.1,1347159.1
