Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 3 · The reporting stack: which tool answers which question
The four tools and what each is for
Lesson 22 of 177 · 2 min
Four tools, and each was designed for a different shape of question. BI PUBLISHER produces a DOCUMENT. A query underneath, a layout on top, and an output whose every millimetre you control — an invoice, a payslip, a statement, a fixed-format file a bank will read. It is the only one of the four that can produce something with a required layout, and that is usually the whole reason to choose it. OTBI produces an ANALYSIS. A business user drags attributes from a subject area, filters, pivots, charts, saves. Nobody writes SQL, and the model underneath applies that user's own data security. It is for looking at things and changing your mind, which is most of what people mean when they say "report". SMART VIEW puts the same data in a spreadsheet, live, for people who will do their own arithmetic on it whatever you build. Fighting that is a…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Fusion Technical: Reports, Data, Integrations and Extensions, with a certificate on completion and a fourteen-day refund window.