OTBI (Oracle Transactional Business Intelligence)

Oracle Transactional Business Intelligence (OTBI) delivers a flexible and easy-to-use analysis tool that helps you to gain real-time insight into transactional data, understand data patterns and be alerted to key events and data anomalies.

Key Benefits

• Oracle Transactional Business Intelligence (OTBI) is fully integrated with Fusion HCM and requires no additional system or security configuration.
• Fusion HCM uses trees to manage employee and organisational structure. Trees are flattened and propagated to Oracle Transactional Business Intelligence (OTBI) as reporting hierarchies so you can easily analyse data by rolling up or drilling the various hierarchies, i.e., supervisor, department, position hierarchy, etc.
• Oracle Transactional Business Intelligence (OTBI) supports multi-language translation. The reporting user interface and metadata can switch to your chosen local language.
• You can easily embed an Oracle Transactional Business Intelligence (OTBI) report or dashboard in a Fusion page through personalisation.

Key features

• Self-service ad hoc analysis — Easily access, analyse, and use the transnational information with minimum maintenance and fewer reports to maintain using the Oracle BI EE platform.
• Access real-time data — Create reports with real-time transactional data without any latency directly from Oracle Fusion applications’ data.
• Seamless integration with Oracle Fusion applications:
  • Single sign-on and Presentation subject areas and folders are designed according to business function and role.
  • Security setup—Transactional Business Intelligence delivers a security integration with Oracle Fusion applications.
  • Integrated security—Transactional Business Intelligence uses the same data security as Oracle Fusion applications, with no separate data security setup required for
• Transactional Business Intelligence. Any changes done on Oracle Fusion applications’ data security are immediately available in Transactional Business Intelligence.
• Report building capability—Built on top of the Oracle BI EE platform for ease of use, Oracle Business Intelligence Answers is used as the interface to build and modify reports for ad hoc analysis. You can also use BI Composer to build and modify reports.
• Value-added and cross-functional content—Derived Measures in addition to operational metrics from Oracle Fusion applications with cross-functional analysis.
• Enhanced usability—Folder structures similar to Oracle Fusion applications, User Interface labels propagated to the Presentation layer, prebuilt calculated measures, and ease of setup and configuration.
• Flexible and extensible—Architected to seamlessly leverage Oracle Fusion applications concepts; for example: flex fields, trees, single sign-on, embedded content, and multilanguage support. 8. Customisable—Add additional attributes, measures, or reports.