Oracle Business Intelligence Application (OBIA)
pre-built solutions has two configuration methods. First one is with
Informatica/DAC which is in place since 2001 while the other one is with Oracle
Data Integrator (ODI) which seems Oracle’s strategic offerings.
This blog is an attempt to list down significant
differences between these two configurations offerings. In addition introduce
the new product sets which is been used for configuration and functional setup
in later version i.e. OBIA 11.1.1.7.1
Significant Differences
There are number of significant differences
between how OBIA 7.9.6.4 & OBIA 11.1.1.7.1 works.
In the 7.9.6 release, the ETL workflows, mappings,
configuration etc are done using Informatica Powercenter, the Data Admin
Console and manually editing configuration files. In the 11.1.1.7.1 release,
the ETL workflows, mappings, configuration etc are done using ODI,
Configuration Manager and Functional Setup Manager.
Some of the highlights of differences are as
follows
- ODI Load Plans now replace the Informatica execution plans.
- ETL tool is now embedded with ODI and load plans are generated and run using a JEE agent via the ODI studio and therefore there is no further need for a Informatica or DAC server.
- Informatica mappings, mapplets and workflows have also now been replaced by pre-built ODI content which includes repository objects such as packaged ETL mappings, Interfaces and scenarios
- The BI Configuration Manager(BIACM), Functional Setup Manager(FSM) and the Oracle Data Integrator all work together to replace a lot of the functional configuration that was previously done using the DAC
- Domain mappings now done within the Configuration Manager, lookup files are no longer needed and a lot of the domain mappings that were previously done in CSV files are also no longer required. ( There are some exceptions where CSV files are required)
The web applications introduced as part of
OBIA 11.1.1.7.1 is a significant change from the OBIA 7.9.6.X versions; it
offers homogeneity and better way of managing configurations.
BIACM
BIACM is a Web application for setting up and
maintaining an Oracle Business Intelligence Applications environment and
provides the following features:
- Contains the setup objects for Oracle BI Applications.
- Provides administrative GUIs for setup and configuration.
- Recommended for ongoing administration and maintenance of functional setups.
- Quick review of the setup values and for troubleshooting.
A screen snapshot for BIACM for financial
Analytics is as follows
FSM
FSM enables you to manage and perform
functional configuration tasks for configuring Offerings and provides the
following features:
- Oracle BI Applications Configuration Manager leverages FSM to provide Task based implementation, with guided set of sequenced tasks and dependency management
- Provides phased implementations capability.
- FSM for Oracle BI Applications is different from the Oracle Fusion Functional
Setup Manager:
− FSM for Oracle BI
Applications includes only the features applicable for Oracle BI Applications
functional setup.
− FSM for Oracle BI
Applications has lighter Tech stack dependencies.
- FSM is launched from Oracle BI Applications Configuration Manager to perform functional configurations.
- FSM is recommended for initial implementation.
- FSM invokes Oracle BI Applications Configuration Manager UI for setup tasks.
A screen snapshot for FSM for financial Analytics is as follows
Roles
for System Configuration and Management
To access Oracle BI Applications
Configuration Manager or Functional Setup Manager, following roles are
supported
BI Applications Administrator
Users with the BI Applications Administrator
Duty Role have access to all Oracle BI Applications Configuration Manager UIs
and all FSM UIs. For Oracle BI Applications Configuration Manager, only users
with this duty role can perform System Setups.
BI Applications Developer
Users with the BI Applications Functional
Developer Duty Role have access to Oracle BI Applications Configuration Manager
UIs except for the System Setup screens. In FSM, these users have access to the
list of functional setup tasks assigned to them, and can execute setup tasks
(that is, using the Go to Task option in FSM).
BI Applications Implementation Manager
Users with the BI Applications Implementation
Manager Duty Role have access to the Oracle BI Applications Configuration
Manager Overview page and dialogs for the Export and Import of Setup Data. In
FSM, these users have access to Configure Offerings and Manage Implementation
Projects UIs, but they cannot execute setup tasks (that is, they do not have
access to the Go to Task option in FSM).
I believe this is just a beginning of new chapter
in OBIA Analytical Application world, many more to come in very near future.
No comments:
Post a Comment