Developer(s) | Oracle Corporation |
---|---|
Stable release | |
Operating system | Linux and Windows |
Type | |
License | Oracle Technical Network License (Proprietary) |
Website | Oracle BI Publisher |
Oracle BI Publisher is the reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools. Use your web browser or familiar desktop tools to create everything from pixel-perfect customer facing documents to interactive management reports against practically any data source. To register a data source, navigate to Reporting Tools > BI Publisher > Data Source and clink on Add New Value. As mentioned earlier, PeopleSoft presently offers support for three data source types – Connected Query, PS Query and XML File.
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 EdwardsEnterpriseOne application 8.12[1] and PeopleSoftEnterprise 9,[2] and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications.[3] When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.
BI Publisher separates the creation of data from the process of formatting it for different uses. The engine can format any well-formed XML data, allowing integration with any system that can generate XML, including Web Services[4] or any data source available through JDBC.[5] BI Publisher can merge multiple data sources into a single output document.
- 1Template design
- 3Server
Template design[edit]
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[edit]
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[edit]
Starting with the 11g release, BI Publisher also offers a pure web based layout editor that allows users to create managementreports 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 stylesheetsand 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[edit]
XML Publisher templates can be designed in Adobe Acrobat 5.00 and above, using the native form field capabilities.
Adobe Flash[edit]
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[edit]
In addition to using the tools mentioned above, users can also upload existing XSL stylesheets to run with BI Publisher.
Data Template/Model design[edit]
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 XMLconfiguration file. In 11g the data model can be created using a web based visual data model builder.
Server[edit]
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:
- Plain Text (e.g. EFT/EDI)
Delivery Manager[edit]
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:[6]
- Internet Printing Protocol (IPP)
The Delivery Manager provides an open architecture that allows custom delivery channels to be implemented.
References[edit]
- ^Alex Woodie (April 27, 2006). 'Oracle Delivers New Goodies with EnterpriseOne 8.12'. Retrieved 2006-12-12.
- ^Jeremy Kirk (June 26, 2006). 'Oracle releases PeopleSoft version 9'. IDG News Service. Retrieved 2006-12-12.
- ^'Oracle XML Publisher Enterprise; An Oracle White Paper'(PDF). May 2006. Retrieved 2006-12-12.
- ^'Web Service Datasources for XMLP Enterprise'. Retrieved 2006-12-11.
- ^'Connecting to SQL Server with XMLP Enterprise'. Oracle XML Publisher Blog. Retrieved 2006-12-11.
- ^'Oracle XML Publisher'. Retrieved 2006-12-11.
External links[edit]
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Oracle_BI_Publisher&oldid=799028991'
This section discusseshow to search the BI Publisher report repository.
Access the BI ReportSearch page (Select Reporting Tools > BI Publisher > BIP ReportSearch.)
![Reports Reports](/uploads/1/2/5/6/125625988/539110182.jpg)
Enter criteria to filterthe reports to list. BI Publisher Report Search ignores criteria forfields that are blank.
Field or Control | Definition |
---|---|
Report DefinitionID | (Optional) Select thename of the report definition to search on. If you want to use additionalsearch keys, you must select the Report Definition ID. |
Folder Name | (Optional) Select aspecific folder to list only the reports that are contained in thatfolder. |
Created On | (Optional) Use the calendar,or enter a specific date to list only reports that are created onthat date. |
Instance andto | (Optional) Enter a rangeof process instances. Leave the to field blankto list all instances after the number that you enter in theInstance field. |
Last | (Optional) Use to displayonly those reports that were created in the last number of days, hours,or minutes. For example, to list only those reports that were createdwithin the last two hours, enter 2 and select Hours. |
Report Manager | Click to go to the ReportManager. See Understanding Report Manager. |
Process Monitor | Click to go to the ProcessMonitor. See Understanding Process Monitor. |
See Viewing Reports.
Viewing ReportsUsing Additional Search Keys
Additional search keysare available based on the Report Definition ID.
Users can also searchby the following criteria for bursted reports:
- A specific value in the Burst By field.This is a read-onlyfield that appears automatically when a value is set in the Burst by fieldof theReport Definition > Bursting page.
- Up to two additional valuesin the predefined bursting Search Key fields.These drop-down listboxes display the values set in the Search Keys region of theReport Definition > Bursting page.
To view bursted reportsusing the additional search keys:
- Select the Case Sensitive check box to perform a case-sensitive search.
- For the Burst By field,select a search operator.
- Enter a value to searchon.
- For the additional Search Key fields,select the search field name, search operator and search value.
See Setting Bursting Options.