An Oracle blog about BI Publisher

BI Publisher 11g - is here!

Guest Author

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!

Join the discussion

Comments ( 20 )
  • Sunder Iyer Friday, May 13, 2011
    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,
  • Kan Nishida Wednesday, May 18, 2011
    Hi Sunder, the Linux version should be available as well and already been certified.
  • guest Tuesday, May 24, 2011
    With which versions of Oracle is BI Publisher version compatible?
  • Kan Nishida Tuesday, May 24, 2011
    You can check the full certification matrix from here.
    As to the Oracle database certification here is the list:
    Oracle, Oracle, Oracle
  • Brent Lowe Friday, June 3, 2011
    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?
  • Kan Nishida Friday, June 3, 2011
    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.
  • Brent Lowe Friday, June 3, 2011
    Thanks for the response, appreciate it!
  • guest Tuesday, June 7, 2011
    Where I can find upgrade patches from to ? Are patches available in OTN at all ?
  • guest Wednesday, July 20, 2011

    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!

  • Kan Nishida Thursday, July 21, 2011

    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.

  • Bart Peeters Thursday, July 21, 2011

    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?

  • Kan Nishida Thursday, July 21, 2011

    Hi Bart, that's perfect!

  • Sunder Iyer Monday, August 1, 2011

    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?



  • Bart Peeters Tuesday, August 16, 2011

    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!

  • Kan Nishida Tuesday, August 16, 2011

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

  • Sunder Iyer Friday, August 19, 2011


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

  • guest Thursday, March 8, 2012

    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.

  • Tim Dexter Thursday, March 8, 2012

    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.



  • Vyagh Wednesday, May 9, 2012


    Is Bi Publisher for Mac OS X available?



  • Sudhir Saturday, November 2, 2013

    Hi there

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


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.