• 28 July 2026

BI Designer+ for Oracle BI Publisher: Template Builder, Layout Editor, and BI DesignerPlus

Designing reports in Oracle BI Publisher (now rebranded as Oracle Analytics Publisher) involves two primary tools: the Template Builder for Word, a Microsoft Word add-in for creating RTF template-based layouts, and the browser-based Layout Editor for more interactive, drag-and-drop report design. For Oracle HCM Reporting and Oracle Fusion environments where standard report design falls short, DataTerrain has developed BI DesignerPlus. This next-generation plugin extends Oracle BI Publisher with advanced functions unavailable in the native toolset. This guide covers both the standard Oracle BI Publisher design environment setup and what BI DesignerPlus adds for users who need more advanced report capabilities.

What Is Oracle BI Publisher and the BI Designer Environment?

Oracle BI Publisher is an enterprise reporting and publishing application that extracts data from multiple sources, applies layout templates, and delivers reports in formats including PDF, Excel, and interactive HTML. The design environment has two layers. The BI Publisher Desktop component installs the Template Builder for Word and Analyzer for Excel as add-ins within Microsoft Office, enabling report designers to create and test RTF template layouts using familiar Word tooling with sample XML data loaded for preview. The browser-based Layout Editor, accessed directly within the Oracle Analytics Server or Cloud interface, provides a visual WYSIWYG drag-and-drop alternative for users who prefer not to design in Word. For Oracle Fusion environments, the same tools support all Oracle HCM Reporting, finance, and operational reporting needs through the Oracle Analytics Publisher layer embedded in the Fusion Cloud platform.

Oracle BI Publisher
  • Share Post:
  • LinkedIn Icon

Setting Up Oracle BI Publisher Desktop: Template Builder for Word

The Template Builder for Word is the primary BI Publisher Desktop design tool, adding a dedicated BI Publisher tab to Microsoft Word and Excel for offline report layout design and testing. Setting it up correctly requires four steps:

  • Download the correct version: Access the Oracle Analytics Publisher Downloads page on Oracle Technology Network. Ensure you download the matching 32-bit or 64-bit version of Oracle BI Publisher Desktop to match your installed version of Microsoft Office. Mismatched architecture is the most common cause of installation failure.
  • Install as Administrator: Run the installer with Administrator privileges and close all Microsoft Office applications before starting the installation. The installer registers the Template Builder for Word as a COM add-in, which requires elevated permissions to complete correctly.
  • Enable the ribbon tab: If the BI Publisher tab does not appear in Word after installation, navigate to File, Options, Add-ins, Manage COM Add-ins, and confirm that the BI Publisher Template Builder is checked. Unchecked entries here are the most common reason the tab stays hidden after a successful install.
  • Load sample XML data: Once the tab appears, use the Load XML Data option to import a sample data file for your report. This allows the Template Builder to display field names for insertion into the layout and enables in-Word preview of the report output before publishing.

Web-Based Layout Editor: Dynamic Reports in the Browser

The Layout Editor is built directly into the Oracle Analytics Server and Oracle Cloud interfaces, launched from the report definition page without any local installation required. It provides a drag-and-drop interface for adding data elements, charts, tables, and conditional regions to a report layout with immediate visual feedback. The Layout Editor is particularly suited for reports that need interactive output types, including scrollable tables, sortable columns, and cross-filtering between components, which are not available in static RTF template designs. For Oracle Fusion users accessing Oracle Analytics Publisher through Oracle Cloud, the Layout Editor is often the faster path for new report creation because it requires no local software configuration and supports the same data models as RTF template-based reports.

Where Standard Oracle BI Publisher Design Tools Have Limitations

The native Oracle BI Publisher design tools handle standard reporting requirements well. Still, Oracle HCM Reporting and financial reporting teams regularly encounter scenarios where the built-in tools reach their limits. Pivot table creation in the standard Template Builder for Word is constrained to a 5x5 grid of rows and columns, which is insufficient for detailed HR cost reports or multi-dimensional financial summaries. Cumulative running totals require complex XDOFX or XSL function combinations that are error-prone to write manually and difficult to validate within the native editor. The standard Formula Editor supports a limited set of calculations, making complex aggregations across grouped data sets harder than they need to be. And for large multi-section reports common in Oracle HCM Reporting, the native tools do not generate navigable bookmarks in PDF output, requiring manual bookmark creation after the report is published.

BI DesignerPlus: DataTerrain's Advanced Oracle BI Publisher Plugin

BI DesignerPlus is a DataTerrain-developed plugin that extends Oracle BI Publisher beyond its native design constraints, adding the specific capabilities that Oracle HCM Reporting, finance, and operational reporting teams consistently need. It installs alongside the existing BI Publisher Desktop environment. It works within the Template Builder for Word interface rather than replacing it, which means existing report designs remain intact and report developers work in a familiar environment with expanded capabilities.

Key Features of BI DesignerPlus for Oracle Analytics Publisher

BI DesignerPlus adds six specific capabilities that address the most common limitations of the native Oracle BI Publisher design toolset:

  • CUME function for cumulative running totals: The CUME function enables cumulative running totals within reports without requiring manual XDOFX or XSL function construction. This is critical for dynamic financial summaries and performance reports where running totals must accumulate across grouped data sections in Oracle Analytics Publisher.
  • Expanded pivot table capacity: BI DesignerPlus removes the 5x5 constraint on pivot table dimensions, enabling complex cross-tabulated layouts with larger row and column counts. This is essential for Oracle HCM Reporting scenarios that require multi-dimensional workforce cost or headcount analysis.
  • Comprehensive Formula Editor with XDOFX and XDOXSLT support: The Formula Editor in BI DesignerPlus supports over 500 function combinations, including XDOFX SQL-based and XDOXSLT XSL-based functions alongside advanced aggregate calculations. This allows BI professionals to build complex calculations directly within the report layout without external transformation steps.
  • Field Input Explorer for XML data integration: The Field Input Explorer simplifies integrating XML data fields into RTF template layouts through a visual browser rather than manual field name entry. This reduces errors in field mapping and speeds up development for reports drawing from complex Oracle Fusion data models.
  • Automated PDF bookmarking: BI DesignerPlus generates a table of contents based on report hierarchy and automatically creates navigable bookmarks in PDF exports. For large, multi-section Oracle HCM Reporting outputs, this replaces manual bookmark creation and makes reports significantly more navigable for end users and auditors.
  • Intuitive GUI for chart creation: A simplified graphical interface for chart creation within Oracle BI Publisher reduces the configuration steps required to produce standard chart types, allowing report designers to produce high-quality visualizations with minimal manual XML configuration.

Frequently Asked Questions

Oracle BI Publisher Desktop installs the Template Builder for Word as a Microsoft Word add-in. Download the matching 32-bit or 64-bit version from Oracle Technology Network, run as Administrator with Office closed, and enable the COM add-in under File, Options, Add-ins if the BI Publisher tab does not appear.
The Template Builder for Word is a Microsoft Word add-in for designing offline RTF template-based layouts with sample XML data loaded for preview. The Layout Editor is a browser-based drag-and-drop designer built into the Oracle Analytics Server or Cloud interface, suited for interactive reports without local installation.
Yes. Oracle Analytics Publisher is the current rebranding of Oracle BI Publisher. The core functionality, including RTF template design, the Template Builder for Word, the Layout Editor, and scheduled report delivery, remains the same.
BI DesignerPlus adds the CUME function for cumulative running totals, expanded pivot table capacity beyond the 5x5 limit, a Formula Editor with over 500 XDOFX and XDOXSLT combinations, XML data field integration through the Field Input Explorer, and automated PDF bookmarking for large Oracle HCM Reporting outputs.

The standard Oracle BI Publisher design environment, anchored by the Template Builder for Word and the browser-based Layout Editor, covers most reporting requirements in Oracle Fusion and Oracle Analytics Publisher environments. For teams pushing beyond those boundaries, whether through complex Oracle HCM Reporting requirements, large-scale financial summaries, or multi-dimensional pivot table analysis, BI DesignerPlus provides the specific function extensions and usability improvements that the native toolset does not offer, without requiring a change to the underlying Oracle BI Publisher infrastructure.

DataTerrain is a specialist Oracle BI Publisher implementation partner with over 17 years of experience and 400+ US clients. Whether you are setting up a new Oracle Analytics Publisher reporting environment, extending Oracle HCM Reporting with advanced features, or exploring what BI DesignerPlus can do for your specific reporting requirements, DataTerrain brings the expertise and tooling to accelerate your results. Contact DataTerrain for a live demonstration of BI DesignerPlus, or visit our website to explore the full range of Oracle BI Publisher and HCM reporting services.

Explore DataTerrain's Oracle BI Publisher Services

DataTerrain helps organizations design, migrate, and extend Oracle BI Publisher reporting environments:

Related Articles