Master Oracle Fusion BI: Build & Analyze OTBI Reports

Build an Oracle Fusion BI Publisher report with the wizard, create a SQL data model and layout, and save to shared folders for testing and PDF output.

Learn how to run Oracle Fusion OTBI reports from the catalog or by scheduling a job, selecting layouts, data models, and output formats like PDF or Excel.

Learn to run a fusion publisher report by creating an enterprise scheduler job, using report analytics to set the path and layout, and scheduling a pdf output.

Create a manual report layout in Oracle Fusion BI by building a data model, designing with XML tags, and uploading the layout for catalog execution.

Create manual report layouts in Oracle Fusion BI using a data model and XML templates, export, upload, and run or schedule the report from the catalog.

Explore formatting properties for report layouts, including pdf output security and password protection, and learn how to configure, schedule, and verify pdf reports in the catalog.

Learn to apply currency format in Oracle Fusion BI layouts by using the format currency tag and a format mask, displaying columns with correct decimal and grouping, e.g., INR.

Apply style sheets as templates by creating, uploading to the catalog, and applying them to report layouts to standardize header, footer, date, and PDF output across reports.

Create master detail reports using group level links in Oracle Fusion BI, linking groups via a bind parameter on customer ID and generating a report from the data model.

Create a master detail report using subgroups by building a single query data model, establishing master–child relationships, and moving elements between groups to form grouped layouts with subgroups.

Learn how to use aggregate functions—sum, count, average, first, last, min, max, and summary—within a data model to analyze invoice data in Oracle Fusion BI.

Use expressions to perform arithmetic operations on columns in Fusion DB, including addition, subtraction, multiplication, division, and modulus, to create calculated fields like extended amount and revenue amount.

Utilize the if function in expressions to output invoice line for line type or tax line otherwise, and classify tax rate as low or high.

Learn to use the not operator in expressions to evaluate the user language via the standard user_report_locale variable, returning true or false and driving multi-language layouts with template calls.

Explore expressions in Oracle Fusion BI with the and function, evaluating boolean conditions like revenue is null and tax rate is not null, and using end and ampersand syntaxes.

Understand the or function in OTBI expressions, using revenue and tax rate examples, and learn how short-circuit evaluation affects a third condition and the pipe symbol as or.

Learn how min and max expressions operate in OTBI reports, including single-expression results, salary examples, and the SQL-like comparison used with multiple expressions.

Demonstrates round and sum expressions in OTBI, including rounding extended amount to zero decimals and adding it to revenue amount, and explains string concatenation and Oracle SQL comparison.

Master Oracle Fusion BI: build OTBI reports using bind parameters, test joins, explore data models and datasets, and configure prompt-driven outputs.

Bind parameters in Oracle Fusion BI reports using independent value sets and translated independent lists of values, while handling non-value sets, dependent value sets, and translations in publisher.

Create a table value set from a database query, attach it to a parameter, and use the $FLEX$ concept to dynamically filter values by transaction type.

Explore sub templates in Oracle Fusion BI by creating a data model, main and sub templates, uploading to the catalog, and calling the sub template from the main template.

Learn to create a multi-language OTBI report by building a data model and layout, exporting and editing an xliff translation file, and running translated outputs from the catalog.

Set the report to the user’s language, such as Spanish, to see locale-specific translations in a multi-language report with default html output.

Learn to burst fusion bi reports by splitting outputs via customer id or tr number and delivering them through email, ftp, sftp, or file.

Fix the bursting query to return two invoices by removing duplicate lines or using distinct, then test the bursting workflow to ensure only two emails are sent.

Learn to build an AR invoice report query from scratch in Oracle Fusion BI, linking party, cost accounts, and site data to produce bill-to and ship-to details with parameters.

Learn to build an OTBI invoice report in Oracle Fusion BI by configuring list of values, using Fusion DB data sources, and creating a master-detail layout with RDF.

Master Oracle Fusion BI OTBI reporting by generating AR invoice reports that use for-each section and page break logic to render each invoice on a separate page.

Fix header repetition in AR invoice reports by converting the header into a template, calling it on subsequent pages, and validating the layout and data model queries.

Create dynamic logos in Oracle Fusion BI reports by using a parameterized sub template called logo, called from a main template, with conditional logic for US and UK operating units.

Learn to limit lines per page in BI Publisher by using a lines-per-page variable, tracking the current position, and triggering a page break with a break before page attribute.

Learn to limit lines per page in BI Publisher by declaring a lines-per-page variable and applying page breaks, ensuring headers repeat on every page for consistency.

Learn how to create and attach an Excel template to a data model in Oracle Fusion BI, mapping XML data to elements and groups, and validating the layout.

Learn to build a master detail report in Oracle Fusion BI using an Excel template, including data model setup, master and child queries, layout, tags, and grouping.

Discover how to create an OTBI analysis in Oracle Fusion by selecting a subject area, building a layout, and running the report from browse catalog or home search for output.

Explore how to create and use prompts in Oracle Fusion reports, turning analyses into parameterized prompts driven by supplier values to filter invoices.

Create a supplier invoice listing report in OTBI using a compound layout with titles, logos, and a table layout, including a calculated original amount and page controls.

Learn to set up inline parameter prompts with a business unit input that drives a dependent invoice prompt, configure prompts, enforce required input, and test results across units.

Learn to create ad groups and calculated items in OTBI, group invoice types (debit/credit memos, prepayment, payment request), and apply subtotals and formatting across operating units.

Explore the new calculated item in oracle fusion bi to perform arithmetic with otbi data, compare with grouping, and compute sums, averages, and net invoice amounts including credit and debit memos.

create a master-detail otbi report with a master business unit table and a detail invoices table, including a distinct count by unit and prompts for filtering.

Learn to build and customize dashboards in Oracle Fusion BI OTBI by adding analyses, creating dashboard prompts, and filtering data with master-detail relationships for actionable insights.

Explore how action links in oracle fusion bi enable navigating to content and web pages from a dashboard, and opening standard fusion screens to view invoice details or analyses.