# OTBI vs BI Publisher: Which One Should You Use > Source: https://netray.co/erp-help/fusion-otbi-vs-bi-publisher-when-to-use > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Use OTBI when a business user needs ad hoc, self-service, real-time analysis with no fixed layout. Use BI Publisher when you need a pixel-perfect, scheduled, high-volume, or externally distributed document such as an invoice, check, or statutory report. Most Fusion implementations end up using both, not one instead of the other. ## Kind how-to ## System oracle-fusion ## Erp Oracle Fusion Cloud ERP ## Module Oracle Transactional Business Intelligence / BI Publisher ## Query OTBI vs BI Publisher - which one should I use in Oracle Fusion ## Alternate Queries - when to use OTBI vs BIP - difference between OTBI and BI Publisher Oracle Fusion - Oracle Fusion reporting tool choice OTBI BIP - OTBI real time reporting vs scheduled report ## Applies To Oracle Fusion Cloud ERP and HCM, all editions with standard OTBI subject areas and BI Publisher ## Steps ### Decide which reporting tool fits your requirement **Items:** Ask whether the output needs a fixed, formatted layout, such as an invoice, purchase order, check, or statutory filing - if yes, that already points to BI Publisher. Ask whether the requester is a business analyst who needs to slice and pivot data themselves without waiting on IT - if yes, that points to OTBI. Check data volume and frequency: BI Publisher scales better for large, scheduled, bursty extracts run through ESS; OTBI is tuned for smaller, interactive, real-time queries against subject areas. Check distribution: BI Publisher can output PDF, Excel, Word, or RTF and be emailed, printed, or delivered on a schedule; OTBI output stays inside the application, or exports to Excel from the analysis screen. If the requirement mixes both - a formatted document driven by a flexible data set - build the data model in BI Publisher and let power users adjust prompts, rather than trying to format an OTBI analysis. For a one-off business question, start in OTBI (Navigator > Tools > Reports and Analytics > Create > Analysis) before investing time in a BI Publisher data model and template. ## Sections ### What OTBI Actually Is **Body:** OTBI queries a set of prebuilt subject areas, such as Payables Invoices - Real Time, that sit close to the transactional schema and refresh continuously, so results reflect data entered minutes ago. It is built for self-service: drag-and-drop columns, filters, and pivots without SQL or a data model. ### What BI Publisher Actually Is **Body:** BI Publisher separates a data model - SQL, a view object, or a web service call - from a layout template, typically RTF in Word or an Excel template, so the same data can be rendered as a formatted PDF invoice or a raw Excel extract. It runs through Enterprise Scheduler, so it is naturally suited to recurring, scheduled, or bursty outputs. ### Performance And Governance Differences **Body:** OTBI analyses are easy for end users to build but can be misused to pull very wide, unfiltered data sets that stress the subject area. BI Publisher data models are typically built and tuned by IT or a reporting developer, which adds a delivery cycle but also more control over performance and security exposure. ### A Practical Rule Of Thumb **Body:** If the question starts with "can I quickly see," it is usually OTBI. If it starts with "I need this exact document or extract every period," it is usually BI Publisher. Most implementations end up building a library of both, with OTBI for ad hoc exploration and BI Publisher for the documents that have to look and behave the same way every time. ## Pitfalls - Building a formatted, multi-page statutory report as an OTBI analysis and fighting the tool instead of using BI Publisher's RTF templates. - Scheduling large, unfiltered OTBI exports as a substitute for a proper BI Publisher extract, which is slower and harder to govern. - Assuming OTBI subject area data is identical in structure to the underlying transactional tables - subject areas are curated and sometimes lag or rename fields. - Letting end users build BI Publisher data models without review, since a poorly written SQL data model can be a genuine performance and security risk. - Forgetting that both tools respect data security - a user only sees the rows their data role permits in either OTBI or BI Publisher. ## Ai Angle When someone asks whether they can get something as a report, ERPray grounded on your Fusion metadata can point straight to whether an existing OTBI subject area or BI Publisher data model already answers the question, and draft the analysis or template outline, instead of a business user guessing which tool to open or filing a ticket for something that already exists. ## Faq ### Can OTBI analyses be scheduled like BI Publisher reports? **Answer:** Yes, an OTBI analysis can be embedded in a dashboard that refreshes or added to a schedule, but it still is not intended for pixel-perfect formatted documents; for that, BI Publisher templates remain the better fit. ### Do OTBI and BI Publisher use the same underlying data? **Answer:** They can draw from overlapping data, but OTBI goes through curated subject areas while BI Publisher data models typically query views or tables more directly, or call web services. Numbers should reconcile, but the query paths differ, so minor timing or rounding differences can occur. ### Which one is easier for a non-technical business user? **Answer:** OTBI, by design - it is built for drag-and-drop, ad hoc exploration inside the application without writing SQL or building a template. BI Publisher generally needs someone comfortable with data models and RTF or Excel templates. ### Is BI Publisher being replaced by OTBI in newer Fusion updates? **Answer:** No. Oracle continues to invest in both; they solve different problems, ad hoc self-service versus formatted scheduled documents, and most Fusion customers use both side by side rather than standardizing on one. ## Search terms OTBI vs BI Publisher, Oracle Fusion reporting tools comparison, OTBI subject areas real time, BI Publisher RTF template Oracle Fusion, when to use OTBI, Oracle Fusion ad hoc reporting, BI Publisher scheduled report Fusion, OTBI analysis dashboard, Fusion Reports and Analytics --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json