Oracle BI Publisher

Last updated
Oracle BI Publisher
Developer(s) Oracle Corporation
Stable release
11.1.1.7
Operating system Linux and Windows
Type Oracle database development environment
License Oracle Technical Network License (Proprietary)
Website Oracle BI Publisher

Oracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. Osama Elkady from the Applications Technology Group and Tim Dexter from the Financials Group were the main drivers for the product. It was first released with Oracle E-Business Suite 11.5.10 in 2003. Since then it has been integrated into most of Oracle Products including JD Edwards EnterpriseOne application 8.12 and PeopleSoft Enterprise 9, and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.

Contents

BI Publisher separates the creation of data from the process of formatting it for different uses. [1] The engine can format any well-formed XML data, allowing integration with any system that can generate XML, including Web Services or any data source available through JDBC. BI Publisher can merge multiple data sources into a single output document.

Oracle Corporation's most recent reporting technology is called Oracle XML Publisher (XMLP). It was initially created in order to help Oracle Applications with its reporting issues. Tim Dexter from the Financials Group and Osama Elkady from the Applications Technology Group were the key architects of the project. In 2003, it was originally made available alongside Oracle E-Business Suite 11.5.10. Since then, it has been included in the majority of Oracle Products, such as PeopleSoft Enterprise 9 and JD Edwards EnterpriseOne application 8.12, as well as a standalone version of XML Publisher Enterprise that is independent of Oracle Applications. Its name was changed to Oracle BI Publisher when XML Publisher was integrated into the Oracle BI Enterprise Edition Suite. With the help of BI Publisher, data production and data formatting are kept separate.

Template design

BI Publisher report templates can be designed using the Microsoft Word, Adobe Acrobat, Microsoft Excel (standalone only) and Adobe Flash (standalone only). Templates created using these tools contain embedded fields with properties that determine how the XML data will be merged into the template, using Extensible Stylesheet Language syntax to precisely match the server's engine.

Template Builder for Word

Template Builder is an extension to Microsoft Word that simplifies the development of Rich Text Format templates. Templates created using Template Builder are transformed into XSL Stylesheets that can be used to generate PDF, RTF, Microsoft Excel and HTML outputs.

Layout Editor

Starting with the 11g release, BI Publisher also offers a pure web based layout editor that allows users to create management reports and simple production reports in a WYSIWYG layout editor. The layout editor is written in pure DHTML. As with Rich Text Format templates Reports created in the web based layout editor are transformed into XSL stylesheets and can be viewed in the same output formats. In addition, the layout editor templates (.xpt) can also be viewed in an interactive viewer which allows re-sorting and interactive filtering of existing reports.

Adobe Acrobat

XML Publisher templates can be designed in Adobe Acrobat 5.00 and above, using the native form field capabilities.

Adobe Flash

The 10.1.3.3 release of Oracle BI Publisher offers support for Adobe Corporation's new document format for building interactive forms and reports, called Flex. You can build Flex templates, test them on your desktop, and deploy them to the BI Publisher server to generate Flash output. Users are then able to run the reports from the BI Publisher user interface or schedule them for delivery to report consumers.

XSL Stylesheet

In addition to using the tools mentioned above, users can also upload existing XSL stylesheets to run with BI Publisher.

Data Template/Model design

BI Publisher supports the generation of XML data from SQL queries, web services, XML files and XML HTTP servers, LDAP queries, MDX queries (starting 10.1.3.4.1), Oracle ADF view objects (11g) and Microsoft EXCEL files (11g). While previous version allowed the simple addition through a UI, linking of queries required the creation of an XML configuration file. In 11g the data model can be created using a web based visual data model builder.

Server

The server is a Java EE application that can be deployed to any Java EE container. The XML data is fed through the templates to produce XSL Formatting Objects, which can be transformed into most popular output formats:

Delivery Manager

The Delivery Manager is responsible to deliver the output to different destinations, such as fax and email, with the flexibility of delivering the same output to different destinations; e.g. HTML format can be sent to email while a PDF format sent to the printer.

The following protocols are supported: [2]

The Delivery Manager provides an open architecture that allows custom delivery channels to be implemented.

Related Research Articles

In computing, the term Extensible Stylesheet Language (XSL) is used to refer to a family of languages used to transform and render XML documents.

XSLT is a language originally designed for transforming XML documents into other XML documents, or other formats such as HTML for web pages, plain text or XSL Formatting Objects, which may subsequently be converted to other formats, such as PDF, PostScript and PNG. Support for JSON and plain-text transformation was added in later updates to the XSLT 1.0 specification.

In computing, the Java API for XML Processing, or JAXP, one of the Java XML Application programming interfaces, provides the capability of validating and parsing XML documents. It has three basic parsing interfaces:

DocBook is a semantic markup language for technical documentation. It was originally intended for writing technical documents related to computer hardware and software, but it can be used for any other sort of documentation.

<span class="mw-page-title-main">Adobe ColdFusion</span> Rapid Web app development platform

Adobe ColdFusion is a commercial rapid web-application development computing platform created by J. J. Allaire in 1995. ColdFusion was originally designed to make it easier to connect simple HTML pages to a database. By version 2 (1996) it had become a full platform that included an IDE in addition to a full scripting language.

XFA stands for XML Forms Architecture, a family of proprietary XML specifications that was suggested and developed by JetForm to enhance the processing of web forms. It can be also used in PDF files starting with the PDF 1.5 specification. The XFA specification is referenced as an external specification necessary for full application of the ISO 32000-1 specification. The XML Forms Architecture was not standardized as an ISO standard, and has been deprecated in PDF 2.0.

Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer and Oracle Application Server Reports Services.

Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a product from Arbor Software, which merged with Hyperion Software in 1998. Oracle Corporation acquired Hyperion Solutions Corporation in 2007. Until late 2005 IBM also marketed an OEM version of Essbase as DB2 OLAP Server.

A pivot table is a table of values which are aggregations of groups of individual values from a more extensive table within one or more discrete categories. The aggregations or summaries of the groups of the individual terms might include sums, averages, counts, or other statistics. A pivot table is the outcome of the statistical processing of tabularized raw data and can be used for decision-making.

The identity transform is a data transformation that copies the source data into the destination data without change.

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS.

<span class="mw-page-title-main">Template processor</span> Software designed to combine templates with a data model to produce result documents

A template processor is software designed to combine templates with data to produce resulting documents or programs. The language that the templates are written in is known as a template language or templating language. For purposes of this article, a result document is any kind of formatted output, including documents, web pages, or source code, either in whole or in fragments. A template engine is ordinarily included as a part of a web template system or application framework, and may be used also as a preprocessor or filter.

<span class="mw-page-title-main">Adobe LiveCycle</span> Java EE server software

Adobe LiveCycle Enterprise Suite (ES4) is a service-oriented architecture Java EE server software product from Adobe Systems used to build applications that automate a broad range of business processes for enterprises and government agencies. LiveCycle ES4 is an enterprise document and form platform that allows capturing and processing information, delivering personalized communications, and protecting and tracking sensitive information. It is used for purposes such as account opening, services, and benefits enrollment, correspondence management, requests for proposal processes, and other manual-based workflows. LiveCycle ES4 incorporates new features with a particular focus on mobile devices. LiveCycle applications also function in both online and offline environments. These capabilities are enabled through the use of Adobe Reader, HTML/PhoneGap, and Flash Player clients to reach desktop computers and mobile devices.

<span class="mw-page-title-main">RefDB</span>

RefDB is a client/server reference database and bibliography tool for markup languages like SGML, XML, and LaTeX. It is suitable for standalone use for the purpose of self-archiving, but can be used as an institutional repository as well. Data storage proper is done in one of several supported SQL database engines. RefDB runs on Unix-like operating systems and on Windows/Cygwin. RefDB is licensed under the GPL.

Arbortext Advanced Print Publisher is commercial typesetting software application sold by Parametric Technology Corporation.

XQuery is a query and functional programming language that queries and transforms collections of structured and unstructured data, usually in the form of XML, text and with vendor-specific extensions for other data formats. The language is developed by the XML Query working group of the W3C. The work is closely coordinated with the development of XSLT by the XSL Working Group; the two groups share responsibility for XPath, which is a subset of XQuery.

Innovative Routines International (IRI), Inc. is an American software company first known for bringing mainframe sort merge functionality into open systems. IRI was the first vendor to develop a commercial replacement for the Unix sort command, and combine data transformation and reporting in Unix batch processing environments. In 2007, IRI's coroutine sort ("CoSort") became the first product to collate and convert multi-gigabyte XML and LDIF files, join and lookup across multiple files, and apply role-based data privacy functions for fields within sensitive files.

References

  1. Bozdoc, Daniela (2011-11-07). Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting. Packt Publishing Ltd. ISBN   978-1-84968-319-7.
  2. "Oracle XML Publisher" . Retrieved 2006-12-11.