BI Publisher 11g - is here!

New Oracle BI Publisher 11g Release is released! Here is a list of the new features.


Much Faster Interactive Reporting Experience

Using BI Publisher to interact with your data is snappy. Generating interactive report output uses less memory and is faster than ever. BI Publisher’s highly optimized, three layer caching mechanism provides a highly responsive, interactive reporting experience.

New Interactive Component - List

The List component is a nifty way to filter data in an interactive report. When you click values in the list, BI Publisher automatically filters the data in the report. In the Layout Editor you can set the orientation of the List to be horizontal or vertical and over 30 other options to make it visually appealing for your consumer needs. Lists are another great way to interact with your report to gain more insight. See a quick demo



Both Native and Web Apps for iPhone & iPad

More and more business tasks are performed on mobile devices like iPhone and iPad, so why not browse reports and interact with your data on your mobile device with BI Publisher? Simply access your BI Publisher reports with Safari or other browsers on your iPad or iPhone, or install the Oracle BI Mobile App for iPhone and iPad to enjoy the same rich, fast interactive reporting experience as on your desktop or laptop. See sample pictures.

Enterprise Reporting Platform for Oracle - E-Business Suite

BI Publisher now supports Oracle E-Business Suite’s data level security based on user responsibility and allows you to switch responsibilities on the fly. You can use BI Publisher to view, manage, and deliver reports against E-Business Suite data and join and aggregate with data from other data sources. Utilities are available to help you convert from Oracle Reports and upgrade to BI Publisher 11g. Start taking advantage of many of the great BI Publisher 11g new features with your E-Business Suite data today.



New Data Source – Local Excel File

Often times you need data in Excel to supplement other data or you need to visualize it quickly. BI Publisher added Excel files as a data source so you could create a report against Excel data located on the server. BI Publisher goes one step further. Now you can upload Excel spreadsheets from your local machine directly to a Data Model. Create reports from the uploaded Excel spreadsheet or join it and aggregate it with other data sources. Reporting with local Excel files is a great way to empower your users to visualize and share data easily and still maintain a centralized report environment. See a quick demo

New Template Type - Excel Template

Some users just love Excel, so we added Excel as a report layout design option. In addition to the existing template options like BI Publisher Templates, RTF, PDF, Flash, and others, you can now use Excel to design your report the way you want, using custom functions and Excel Macros to split data across multiple sheets, calculate values dynamically, then share with your colleagues.



Auditing and Monitoring

Auditing is not just about compliance, it’s a way to improve customer service by understanding what your users like to do, when and how they access and view reports. BI Publisher included a framework to help IT Administrators collect data required for auditing. BI Publisher enhances the audit and performance information captured and introduces a method to store the data into a database. Now you can use BI Publisher to visualize, analyze and report on your auditing and performance information. See a quick demo.

New Output Format Type – Native Excel 2007 Output

Now you can download your report as Excel 2007 format and open it with the latest Excel on both Windows and Mac with high fidelity formatting and layout. You can use repeating groups in your report to automatically group data in separate worksheets. With this format option the downloaded Excel file is 70% smaller compared to other Excel output types, which makes it easier to share your report in Excel with your colleagues.



Reports Development Life Cycle Management

Developing reports often involves multiple phases and processes before going live. Reports need to be moved to a testing environment after the development and then to the production environment. You can use the new BI Publisher Catalog Utility to move your reports either one at a time or in batch from one environment to another all without shutting down servers so users can continue to generate the mission critical documents and reports they need.

Also, we have many more enhancement requests implemented in this release and fixed bugs from the previous release. Try download from here and start BI Publisher 11g today!

Want to learn more about BI Publisher?


Follow us @bipublisher for our latest news, inside scoop, or tweet us your feedback!


Connect with other BI Publisher professionals!


Find How-to and solutions over 500 articles!


Subscribe our channel and check our introduction and How-to videos!


Ask any question you have and get answered at our Discussion Forum!


Thanks Kan! I am so excited to get my hands on the new version but the certification matrix does not show to be ready for Linux yet. As always, thanks for the great information. Best regards, Sunder

Posted by Sunder Iyer on May 13, 2011 at 02:36 AM MDT #

Hi Sunder, the Linux version should be available as well and already been certified.

Posted by Kan Nishida on May 18, 2011 at 10:56 AM MDT #

With which versions of Oracle is BI Publisher version compatible?

Posted by guest on May 24, 2011 at 01:58 AM MDT #

You can check the full certification matrix from here. As to the Oracle database certification here is the list: Oracle, Oracle, Oracle

Posted by Kan Nishida on May 24, 2011 at 03:43 AM MDT #

Regarding the "Enterprise Reporting Platform for Oracle - E-Business Suite". Is the licensing model changing for BIP in EBS changing to allow use of BIP-E?

Posted by Brent Lowe on June 02, 2011 at 11:52 PM MDT #

Hi Brent, we're not changing the current licensing. In order to use BIP Enterprise for EBS customers they need to have the BIP Enterprise license.

Posted by Kan Nishida on June 03, 2011 at 03:41 AM MDT #

Thanks for the response, appreciate it!

Posted by Brent Lowe on June 03, 2011 at 03:55 AM MDT #

Where I can find upgrade patches from to ? Are patches available in OTN at all ?

Posted by guest on June 06, 2011 at 09:42 PM MDT #

Hi Kan, I just found this blog post as I was looking for more info about the output format types of BIP 11g.

I see, in, you can export your reports to native Excel 2007.
Do you have any idea if support for native Word 2007 (or its Open Office equivalent) will be available too in the near or far future?

Thanks in advance for your reply!

Posted by guest on July 20, 2011 at 04:08 AM MDT #

No support for .docx and no plan currently. My understanding is the most users would view the reports in HTML, PDF, and Excel. And for the PDF and Excel the pixel-perfect format/layout is requested, but haven't heard the same for other formats. Let me know if you have a specific requirement.

Posted by Kan Nishida on July 21, 2011 at 03:26 AM MDT #

Hi Kan, thanks for your answer.

The customer I work for has a specific case where we would need .docx as output format.
Together with the customer, I have described the case in a document and we will submit this as an enhancement request to Oracle next week.
As soon as the ER is submitted, I can send you the ER-number so you can have a look at it. If this would be okay for you?

Posted by Bart Peeters on July 21, 2011 at 03:54 AM MDT #

Hi Bart, that's perfect!

Posted by Kan Nishida on July 21, 2011 at 04:03 AM MDT #

Hi Kan,
I just upgraded to version and was hoping to try out the new MS Excel templates. According to the documentation - "The Template Builder for Excel is installed automatically when you install the Template Builder for Word. The tools can be downloaded from the Home page of Oracle Business Intelligence Publisher or Oracle Business Intelligence Enterprise Edition, as follows:
Under the Get Started region, click Download BI Publisher Tools.
The Template Builder includes sample Excel templates.
To access the samples from a Windows desktop:
Click Start, then Programs, then Oracle BI Publisher Desktop, then Samples, then Excel.
This will launch the folder that contains the Excel sample templates. "

However, when I download the MS Word Template Builer, I get the version plug-in and I don't see any Excel samples.

Any suggestions?


Posted by Sunder Iyer on August 01, 2011 at 08:36 AM MDT #

Hi Kan,

It's been a while but there has been a lot going on last weeks.

In the mean time, Oracle Support has accepted our SRs about BI Publisher
The export to native MS Word functionality I was talking about is accepted as enhancement request. The bug ID is 12834874.

Our originating SR about this is 3-4205378791.
The SR contains a PDF which explains our case.

Thanks for checking this out!

Posted by Bart Peeters on August 15, 2011 at 09:59 PM MDT #

Thanks Bart for the info. We'll take a look.

Posted by Kan Nishida on August 16, 2011 at 06:43 AM MDT #

Please disregard my earlier comment about MS Excel Template Builder. When I downloaded BI Publisher Desktop for from, I got the latest version along with MS Excel template builder.

Posted by Sunder Iyer on August 19, 2011 at 09:44 AM MDT #

I noticed you deleted all my posts on the BI Publisher forum pointing out the fact that you advertise here support for Native Excel 2007 format, but in fact it doesn't work.

I thought your forums were for the community to promote truth and understanding about your products.

Posted by guest on March 08, 2012 at 01:54 PM MST #

Hi Guest
Your forum posts should not have been deleted. Whats your user name and I'll see if we can recover them?
Here's my take on the Excel 2007 claim above:
Not false, maybe not clear enough on the details but not false. In 11g you can
now generate Excel 2007 outputs from your RTF.
You are able to now produce multi tabbed output from your RTF templates.
The Excel templates still only support Excel or the older Excel 2000 formats
and not the later 2007 format. That I believe is in the works.

I have just tried generating Excel 2007 output with an RTF template and its working fine.



Posted by Tim Dexter on March 08, 2012 at 02:28 PM MST #


Is Bi Publisher for Mac OS X available?


Posted by Vyagh on May 09, 2012 at 10:36 AM MDT #

Hi there
What's the maximum number of table columns that are supported for a MS Word RTF template?

Posted by Sudhir on November 02, 2013 at 07:36 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« July 2016