Objective:

This training article is intended to provide an overview of Oracle Transactional Business Intelligence and its benefits in business decision making.

What Oracle Transactional Business Intelligence is all about?

Oracle Transactional Business Intelligence (OTBI) in Oracle Fusion is a set of pre-seeded yet customizable analysis structures that Fusion Applications users can access to create ad hoc reports, dashboards and alerts to aid daily decision-making. It helps in

• Building rich, visual and interactive reports and publish it to multiple users.
• Creating reports using real time transactional data.
• Enabling the business users to access, analyze, and use the transactional information.
• Perform self- service, ad-hoc analysis.
• Make better operational decisions based on real time analysis.

OTBI is fully integrated with Fusion applications (roles, flex fields, lookups, and trees). There is no need for additional implementation steps to map security or provide configuration inputs.  When you install and configure Oracle Fusion Applications you automatically install the Oracle Business Intelligence components to enable the reporting and analytical features of the application. Let us discuss the reports and analytics in detail.

Reports and Analytics in OFA:

Reports and analytics in Oracle Fusion Applications are built using Oracle Business Intelligence tools and technologies. Analytics or analytical reports are charts and tables of specific set of data. An analysis can also be embedded in the dashboard. Dashboards are the collection of analyses such as Employee expense dashboard in fusion financials, absence and accrual dashboard in HCM, etc. The analyses and dashboard can report on real time transactional data or on historical data. The tools for administering reports and analytics are-

• Oracle Business Intelligence Presentation Catalog stores Reports, analyses, and dashboards used in Oracle Fusion applications pages.

• Oracle Business Intelligence Publisher provides the ability to create and format high quality reports across Oracle Fusion Applications in general, including Oracle Fusion General Ledger. It applies templates, designed by your users in familiar desktop tools, to standard extracts and reports.

        * Report layouts using familiar desktop tools, such as Adobe Acrobat PDF, Word, and Excel

              * Ability to create one template to provide reports in many languages

        * Reports published in various outputs such as Word, Excel, PDF, RTF, and HTML

              * Scheduled reports for delivery to a wide range of destinations

All the reports, analyses and dashboards are stored in BI Presentation catalog and as the name suggests, the catalog stores the application content in a directory structure of individual files. Let us see how to navigate and identify objects in the catalog.

• Navigation : Navigator >Tools >Reports and Analytics
• In Reports and Analytics pane click Browse Catalog
• We will be redirected to the BI Catalog within Oracle Business Intelligence. Click on Shared Folders to get the complete product family in the catalog as shown below

• We can see all the related reports pertaining to the object chosen.

Anjan Mukerji

Add comment