News and Views: Drive Smart Decisions with Cloud Analytics, Machine Learning and More

Pixel Perfect Reporting Comes to Oracle Analytics Cloud

Guest Author

For all you BI Publisher fans, here is the good news - BI Publisher is now available with Oracle Analytics Cloud.

Oracle Analytics Cloud (OAC) is a scalable and secure public cloud service that provides a full set of capabilities to explore and perform collaborative analytics for your enterprise. You can take data from any source, explore with Data Visualization and collaborate with real-time data. It is available in three flavors - Standard Edition, Data Lake Edition, and Enterprise Edition, with Standard Edition giving the base ability to explore data, Data Lake Edition allowing insights into big data, and Enterprise Edition offering the full platter of data exploration, big data analytics, dashboard, enterprise reporting, Essbase etc. Refer to this documentation for additional details on different editions.

With OAC 17.4.5 Enterprise Edition, now you can create pixel-perfect reports and deliver to a variety of destinations such as email, printer, fax, file server using FTP or WebDAV, Webcenter Content and Content & Experience Cloud. The version of BI Publisher here is

If you have used BI Publisher on premises, the experience will be very similar feature wise and look-and-feel wise, and therefore you will find it easy to get on-board. If you are new to BI Publisher, you will now be able to create pixel perfect and highly formatted business documents in OAC such as Invoices, Purchase Orders, Dunning Letters, Marketing Collateral, EFT & EDI documents, Financial Statements, Government Forms, Operational Reports, Management Reports, Retail Reports, Shipping Labels with barcodes, Airline boarding passes with PDF417 barcode, Market to Mobile content using QR code, Contracts with fine-print on alternate page, and Cross-tab reports.

You can connect to a variety of data sources including BI Subject Areas, BI Analysis, and RPD; Schedule your report to run once or as a recurring job; and even burst documents to render in multiple formats and be delivered to multiple destinations.

Can we move from BI Publisher on premises to BI Publisher on OAC?

Well yes, you can. You will have to understand your on premises deployment and plan accordingly. If your data can be migrated to OAC, that will be the best otherwise you can plan to extend your network to Oracle Cloud allowing OAC to access your on premises data. The repository can be migrated by archiving and un-archiving mechanism. User data management will be another task where application roles from on premises will need to be added to OAC application roles. Details on this will be coming soon.

Benefits of BI Publisher on OAC

First of all, OAC comes with many great features around data exploration and visualization with advanced analytics capabilities. BI Publisher compliments this environment for pixel perfect reporting. So now you have an environment that is packed with Industry leading BI products providing an end-to-end solution for an enterprise. 

Managing Server instances will be a cakewalk now, with just a few clicks you will be able to scale up/down to a different compute shape or scale out/in to manage nodes in the cluster, saving you both time and money.

Many self-service features to manage reports and server related resources.

What's new in BI Publisher

BI Publisher in OAC includes all features of and has the following new features in this release:

Accessible PDF Support (Tagged PDF & PDF/UA-1)
New Barcodes - QR Code and PDF417
Ability to purge Job History
Ability to view diagnostic log for online report
Widow-orphan support for RTF template


So why wait? You can quickly check this out by creating a free trial account here. Once you log in, you are in OAC home page. To get to BI Publisher you need to click on the Page Menu on right side top of the page and then select the option "Open Classic Home". BI Publisher options are available under the Published Reporting section in the classic homepage.

For further details on pixel-perfect reporting, check the latest Oracle Analytics Cloud Documentation.

Guest author, Pradeep Sharma is a Senior Principal Product Manager based in India.

Join the discussion

Comments ( 2 )
  • Hoffman Hung Friday, February 16, 2018
    Are we able to upload a predefined Excel template, plug calculated result from OAC into the template, and then deliver back to end user?
  • Michael Singer Thursday, February 22, 2018
    Here's our reply from the author, Pradeep Sharma:

    If "calculated result from OAC" refers to any calculation in DV dataset then this will be a feature in future release. Today BI Publisher can use BI Analysis as a data source, so yes any calculated measure from the subject area or from RPD can be included in the excel template. Moreover, we can use Excel functions in the template on top of the data.
    So I will include a clarification on this in the blog too.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.