Oracle Transactional Business
Intelligence (OTBI) is fully integrated with Fusion Applications and does not
require any additional system configurations. OTBI can be used as soon as the
offerings are configured in Fusion Applications and data is available for
reporting. It helps in real-time adhoc reporting of the enterprise. Data access
and interpretations are easier than before.
OTBI real-time analytics
embedded into the Fusion Applications allows users to easily understand the
data, filter, sort or drill down, extract data in different formats such as
tabular formats or graphical views.
·
Build rich,
visual and interactive reports and publish to multiple users.
·
Create reports
using real time transactional data
·
Easy for business
users to analyze, access, use and understand the transactional data.
·
Integrates well
with the OBIEE features
·
Self-service
& Ad-hoc analysis
·
Enables business
in making better and real-time operational analysis.
·
Built-in
extensibility to enable business users to adapt the application based on the
personal or orgaanizational needs.
Security & Roles
OTBI inherits the user roles
and security profiles from Fusion Applications. So access to the OTBI subject
areas is determined by the Fusion user role. Data that is seen in the OTBI
reports are filtered automatically based on the security profile. OTBI supports
multi-language translation. The reporting user interface and metadata can
switch to your chosen local language. The same report can be deployed in
multiple languages across different countries.
OTBI is built using OBIEE
which is made of 3 layers – the transactional database layer, then the Physical
layer and the Presentation layer. In Fusion Applications, no customizations are
possible in the Physical layer unlike in the on-premise implementation of OBIEE
where the BI Administrator tool caters to the customizations in the layers.
All the OTBI Subject Areas
are suffixed with “Real Time” in the name. Each subject area has one fact
folder and a number of dimension folders. All the OTBI subject areas are
secured by Fusion Applications security as it is integrated with the Fusion
Applications. Each dimension folder within the subject area is linked with the
Fact folder.
Analyses are secured based on
the folders in which they are stored. If the Business Intelligence reports are
not secured using the report privileges, then they are secured at the folder
level by default. Permissions can be set against folders and reports for
Application Roles, Catalog Groups or Users.
Oracle Transactional Business Intelligence (OTBI) reports
can be created using the following data sources.
·
Data Model
·
Spreadsheet
·
Subject Area
Create and Edit Analyses Using Wizard
The function of a wizard is to guide in creating or editing
analyses. Oracle Business Intelligence Answers can be used to create dashboards
and to delete analyses.
Create Analyses
1.
Open Reports and Analytics pane in the work area
2.
Click on Create and select Analysis
3.
Select the subject area that has the columns
required for the report.
4.
Additional subject areas can also be added if
required.
5.
Select the columns to be included in the report
and click on Next
6.
Enter the title for the analysis if required
7.
Select the type of layout for the analysis –
table of graphical and click on Next
8.
Additional options for sorting, filtering and
formatting are also available if required.
9.
Click on Finish to save the Analysis and enter a
Name.
10.
Click on Submit.
Edit Analyses
1.
Open Reports and Analytics pane in the work area
2.
Select the Analysis in the pane and click Edit
3.
Perform the editing based on the options
discussed in the previous section.
4.
To update an existing Analysis, select the same
name in the same folder.
5.
Click on Submit
No comments:
Post a Comment