Explain OTBI: Oracle Transactional Business Intelligence in Oracle Applications

43 / 60

Reportingintermediate

OTBI: Oracle Transactional Business Intelligence

Explain OTBI's role as Fusion Cloud's native, real-time, ad hoc reporting tool

Oracle Transactional Business Intelligence (OTBI) is Fusion Cloud's embedded, real-time ad hoc reporting and analysis tool, built on Oracle BI's (OBIEE-derived) subject areas — pre-built, business-friendly semantic layers that expose Fusion's underlying complex data model as intuitive folders of dimensions and measures, without requiring users to understand the underlying table structure or write SQL. This makes OTBI fundamentally a self-service tool aimed at business analysts and power users, not just IT developers.

OTBI is like a hotel concierge desk that lets guests request custom information (an analysis) using plain language and predefined categories (subject areas) rather than requiring guests to personally search through the hotel's raw operational records — and the concierge only shares information the guest is actually authorized to know.

Key Concepts

Users build Analyses by dragging and dropping fields from a subject area into columns, applying filters, and choosing visualizations (tables, pivot tables, charts), which OTBI then translates into optimized SQL executed directly against Fusion's transactional database in real time — a key differentiator from traditional BI tools that rely on a separate, batch-refreshed data warehouse, meaning OTBI reports always reflect current, live data.

Analyses

OTBI honors the same data security rules as the Fusion application itself — a user only sees data in their OTBI analysis that they'd be authorized to see in the underlying transactional screens, since subject area queries respect the same role-based data security policies, avoiding a separate, error-prone security model for reporting.

data security

Interviewers commonly ask candidates to explain why OTBI shows 'real-time' data compared to traditional data-warehouse-based BI, and to describe practical subject area selection — choosing the right subject area (like 'Payables - Invoices Real Time') for a given ad hoc reporting need.