1) Oracle
Transaction Business Intelligence (OTBI):
OTBI is a robust real-time business intelligence
reporting tool. It runs on Ad-hoc query. It uses the web services to
communicate with database. OTBI is user friendly tool which
is very easy to use. OTBI reports can be developed by selecting the subject
area and drag and drop of columns. Users are not allowed to
add/delete/modify the subject area in OTBI. OTBI is available with Oracle Fusion
Application. OTBI can be used attach reports on various dashboards on fusion
application. All fusion application data security gets applied on OTBI reports.
2) Oracle
Business Intelligence Publisher (BI Publisher):
BIP is fully integrated as a
component inside the OBIEE server(s) in Fusion Application. BIP is flexible
business reporting tool. BIP is used to extract, format and deliver the data
from fusion to third party system. User can create report using BIP by writing
SQL query and then attaching a template to format the data from XML to
consumable format. Different types of templates can be attached to BIP reports
to transform the data format like e-text, RTF, Excel XSLT etc.
BIP is a combination of two objects:
a) Data
Model: It is used to write the SQL query to fetch the data from database
based in XML format. Data model mainly comprises of data sets where
user writes SQL query and select data source.
b) Report:
Reports are sued to format the data from data model like comma separated
values, Excel, PDF etc. Report basically comprises of template like
e-text, RTF Excel etc.
Creating the BIP Report with Data Model
1. Log into the application and click on the Reports and Analysis.
Nav : Home àReports and Analysis
Please click on the below link for
more details:
Fusion BIP – Oracle Fusion BI Publisher Reports
Training Manual
Please Like and Share our FaceBook
page to get more details on Oracle Applications
No comments:
Post a Comment