Published Reporting
Report: Layout-based reporting using Data Models (BI Publisher
reports like PDF, Excel, RTF templates).
Report Job: Scheduling reports oto run at specific times.
Data Model: Define the data source for a report.
Style Template:
A style template is an RTF template that contains style information that can be applied to RTF layouts.
Using a style template has the following benefits:
Enables the same look and feel across your enterprise reports
Enables same header and footer content, such as company logos, headings, and page numbering
Simplifies changing the elements and styles across all reports
Sub Template:
A sub template is a piece of formatting functionality that can be defined once and used multiple times
within a single layout template or across multiple layout template files.
This piece of formatting can be in an RTF file format or an XSL file format.
Some common uses for sub templates include:
Reusing a common layout or component (such as a header, footer, or address block)
Handling parameterized layouts
Handling dynamic or conditional layouts
Handling lengthy calculations or reusing formulae
In the Data Model Editor of Oracle BI Publisher in Oracle Cloud (Fusion
Apps), specifically creating a new data model. Under the "Diagram" tab, you
can create a new Data Set using various sources:
Here are the options visible:
1. SQL Query – Pulls data directly from the Fusion database using SQL.
2. LDAP Query – pull user or directory data.
3. MDX Query – retrieve data from OLAP data sources.
4. Analysis – Uses data from OTBI reports (Subject Areas).
5. HTTP (XML Feed) – External data via URL endpoints.
6. View Object – ADF View Objects (used for pulling data from Application Modules).
7. Web Service – For SOAP-based integrations.
8. CSV File – Upload and use CSV data.
9. Microsoft Excel File – Upload and use Excel data.
10. XML File – Use static XML files.
11. Content Server – Fetches data from UCM server (for attachments or files).
To get started, click the "+" button on the top left, select a data source like SQL Query or View Object,
depending on your requirement.
🔹 SQL Query
Standard way of pulling data directly from Oracle database tables or views using SQL.
Most common for custom financial and operational reports.
🔹 LDAP Query
Fetches data from LDAP directory services (e.g., employee directory, user authentication system).
Used when you need organizational or user-related data stored outside the database.
🔹 MDX Query
Multi-Dimensional Expressions query.
Used to pull data from OLAP Cubes (e.g., Essbase, Hyperion Planning).
Ideal for multidimensional analysis like financial planning, budgeting, forecasting.
🔹 Analysis
Uses an OTBI (Oracle Transactional BI) Analysis as the data source.
You first build an analysis in OTBI, then embed it in BIP.
Great for real-time reporting without writing SQL.
🔹 HTTP (XML Feed)
Consumes external HTTP-based XML feeds (REST/XML services).
Useful for integrating external applications that publish data in XML format.
🔹 View Object
Fetches data from Oracle Application Development Framework (ADF) View Objects.
Pulls data already exposed by Fusion Applications.
Often used for seeded data sources (like invoices, customers).
🔹 Web Service
Consumes SOAP-based Web Services.
Useful for integrating with external systems or Oracle Fusion web services.
🔹 CSV File
Imports data from a CSV file as a data source.
Common for loading flat-file data into reports.
🔹 Microsoft Excel File
Similar to CSV but directly supports Excel files (.xls, .xlsx).
Useful for combining ERP data with user-uploaded Excel reference data.
🔹 XML File
Upload or point to an XML file as the data source.
Often used for pre-structured hierarchical data (like invoices or HR structures).
🔹 Content Server
Fetches files stored in Oracle WebCenter Content Server (UCM).
Used when reports depend on documents or data uploaded into Oracle’s content repository.
👉 In short:
Database driven? → SQL, View Object, MDX
External sources? → Web Service, HTTP Feed, Content Server
File based? → CSV, Excel, XML
Prebuilt analytics? → OTBI Analysis