X

Oracle BI Publisher 12.2.1.4 Now Available !!

Last week Oracle BI Suite 12.2.1.4.0 has been released and that includes Oracle BI Publisher 12.2.1.4.0.  The links to download the installation files, documentation and release notes are available from BI Publisher OTN home page. You can also download the software from Oracle Software Delivery Cloud. The new features introduced in Analytics Cloud Suite for both Data Visualization and BI Publisher are now available for on-prem. You can find the  list of new features for Data...

Friday, April 27, 2018 | Read More

Adding Native Pivot Charts and Tables to your Excel Reports!!

A report in Excel format is a very common requirement and BI Publisher can generate excel output using RTF, XSL or Excel Template. Excel template is recommended when the requirement is to create pixel perfect column width, to use built in excel functions, to create multi-sheet output, to handle preceding zeroes in data, to maintain data formatting, to manage high number of columns of data, etc. How about adding native charts and pivot tables in the excel report ? Well, excel...

Monday, April 2, 2018 | Read More

Introducing Pixel Perfect Reporting in Oracle Analytics Cloud

  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...

Wednesday, December 20, 2017 | Read More

Delivery to Oracle Document Cloud Services (ODCS) Like A Boss

We have moved to a new blogging platform. This was a post from Pradeep that missed the cut over ... In release 12.2.1.1, BI Publisher added a new feature - Delivery to Oracle Document Cloud Services (ODCS). Around the same time, BI Publisher was also certified against JCS 12.2.1.x and therefore, today if you have hosted your BI Publisher instance on JCS then we recommend Oracle Document Cloud Services as the delivery channel. Several reasons for this: Easy to configure...

Wednesday, May 17, 2017 | Delivery | Read More

BIP and Mapviewer Mash Up V

The last part on maps, I promise ... its been a fun ride for me at least :0) If you need to catch up on previous episodes: BIP and Mapviewer Mash Up I BIP and Mapviewer Mash Up II BIP and Mapviewer Mash Up III BIP and Mapviewer Mash Up IV In this post we're looking at map quality. On the left a JPG map, to the right an SVG output. If we ignore the fact that they have different levels of features or layers. Imagine getting the maps into a PDF and then printing them. Its pretty clear...

Monday, May 8, 2017 | RTF | Read More

Supporting Font Encoders on 11g and 12c

We had a couple of requests for some help this past week with customers' custom font encoders. With 11g/12c BIP its not straightforward to embed your code with the BIP code. In fact; its really simple but it took me a while and some trial and error to get the encoder classes to the right spot and in the right format so that BIP could 'see' and use them. In 11g/12c the BIP application is exploded out under the servers below the DOMAIN_HOME, in my 11.1.1.7.x install...

Wednesday, March 15, 2017 | RTF | Read More

Oracle BI Publisher 12.2.1.1 released !!

Oracle BI Publisher 12.2.1.1.0 has been released this week. The links to download files, documentation and release notes are available from BI Publisher OTN home page. The download is also available from Oracle Software Delivery Cloud. The new features in this release are primarily driven by the integrated Cloud Applications and Platform Services. Data Security, Self-Service, Robustness, Easier Integration and Cloud based Data & Delivery has been the main focus here. Check the ...

Saturday, June 25, 2016 | BI Publisher Enterprise | Read More

Best Practices for the cloud !!

Greetings!! Wish everyone a very happy Memorial Day !!  Last week we published in OTN a white paper with title "Oracle BI Publisher Best Practices for SaaS Environments". As the title suggests, this white paper is a compilation of all the best practices for BI Publisher that are relevant to a Cloud Platform, especially for Fusion Applications. You can find the link to this white paper here. We will soon have an updated best practices guide for on-premise installations, so stay...

Monday, May 30, 2016 | BI Publisher Enterprise | Read More

Up in the JCS Clouds !!

Hello Friends, Oracle BI Publisher has been in the cloud for quite sometime ....as a part of Fusion Applications or few other Oracle product offerings. We now announce certification of BI Publisher in the Java Cloud Services!!  Oracle Java Cloud Service (JCS) is a part of the platform service offerings in Oracle Cloud. Powered by Oracle WebLogic Server, it provides a platform on top of Oracle's enterprise-grade cloud infrastructure for developing and deploying new or...

Wednesday, January 27, 2016 | BI Publisher Enterprise | Read More

Oracle BI Publisher 12c released !!

Greetings !! We now have Oracle BI Publisher 12c (12.2.1.0.0) available. You will be able to get the download, documentation, release notes and certification information in BI Publisher OTN home page. The download is also available from Oracle Software Delivery Cloud. This release is part of Fusion Middleware 12c release that includes Oracle WebLogic Server 12c (12.2.1.0.0) Oracle Coherence 12c (12.2.1.0.0) Oracle TopLink 12c (12.2.1.0.0) Oracle Fusion Middleware Infrastructure...

Monday, October 26, 2015 | BI Publisher Enterprise | Read More

PDF417 for E-Business Suite

A while back I wrote up a how to on 2D barcode formats. I kept things generic and covered the basics of getting the barcodes working.  Tony over in Bahrain (for we are truly international :) has had a tough time getting it working under EBS. Mostly to do with the usual bug bear of the JAVA_TOP, XX_TOP and getting class paths set up. Its finally working and Tony wanted to share a document on the 'how' to get PDF417s working under EBS. Document available here. Thanks for sharing...

Monday, October 19, 2015 | RTF | Read More

Orphan Table Rows ... ugh!

This week, orphaned table rows and how to avoid them. Its a bit more subtle than rows breaking across a page border and the solution is a doozy! Im using another video to demonstrate because I don't have to type and grab screen shots, even thou I have one above Its faster and more easily understood, even in my umming and erring English. I'm hip and happening and video help is the future kids! You get to hear my Southern (England) drawl; a great sleep aid for insomniacs! Here it is....

Friday, October 9, 2015 | RTF | Read More

Page Borders and Title Underlines

I have taken to recording screen grabs to help some folks out on 'how do I' scenarios. Sometimes a 3 minute video saves a couple of thousand words and several screen shots. So, per chance you need to know: 1. How to add a page border to your output and/or 2. How to add an under line that runs across the page Watch this!   https://www.youtube.com/watch?v=3UcXHeSF0BM If you need the template, sample data and output, get them here. I'm taking requests if you have them.

Wednesday, August 26, 2015 | RTF | Read More

WebCenter Content - A new Delivery Channel in 11.1.1.9.0 !!

Hi Everyone One of the new features introduced in 11.1.1.9.0 is WebCenter Content (WCC) Server as a delivery channel. Prior to this release, we could manage delivery to WCC (formerly UCM) server using webDAV as explained by Tim in his blog "BI Publisher and WebDAV... done!". However, there were few restrictions No way to include standard or custom metadata. Therefore, there was no description for the documents submitted and searching these documents in WCC was not convenient. Web...

Wednesday, June 3, 2015 | Delivery | Read More

Oracle BI Publisher 11.1.1.9.0 is available !!!

Hi Everyone, I am happy to announce that Oracle BI Publisher 11.1.1.9.0 is released, although I admit that this is almost a week old news now and I am sure some of you may have already known this by now from the BI Publisher homepage in OTN or from other sources. My sincere apologies for the delay here. Thank you Tim for helping me to get back into this blog membership and being patient to allow me put this word out. My activity in the blog has been so less in the past that I...

Monday, May 25, 2015 | General | Read More

BIP scheduleReport with Parameters

I have just spent an hour or so working on getting a sample scheduleReport web service working with parameter values. There are a lot of examples out there but none I have found have the parameters being set. Our doc is a little light on details on how to set them up :) In lieu of that, here's this! // Set the parameter values for the report. In this example we have // 'dept' and 'emp' parameters. We could easily query the params dynamically //Handle...

Wednesday, May 20, 2015 | BI Publisher Enterprise | Read More

How do I ...

An email came in this morning to an internal mailing list, We have an Essbase customer with some reporting requirements and we are evaluating BI Publisher as the potential solution. I'd like to ask for your help with any document, blog or white paper with guidelines about using BI Publisher with Essbase as the main data source. Is there any tutorial showing how to use BI Publisher with Essbase as the main data source? There is not one to my knowledge but trying to be helpful I...

Thursday, February 12, 2015 | BI Publisher Enterprise | Read More

Have your say ...

Another messaging exchange last week with Leslie ... OK, so we practised it a bit after our first convo and things got a little cheesy but hopefully you get the message. Hit this link and you too can give some constructive feedback on the Oracle doc for BI (not just BIP.) I took the survey; its only eight questions or more if you want to share more of your input. Please take a couple of minutes to help us shape the documentation of future. 

Monday, February 9, 2015 | BI Publisher Enterprise | Read More

OAUG BIP SIG ... we're getting the band back together

 Today's post comes to you from Brent at STR Software. If you could help out, it would be greatly appreciated, read on ... First off, if you are not familiar with the term SIG, it stands for Special Interest Group.OAUG facilitates a number of SIGs to bring users together that share common or industries concerning certain Oracle products. Unfortunately, the BI Publisher SIG has been offline for a number of years and has notbeen given the attention it needs to be a useful...

Thursday, January 15, 2015 | E Business Suite | Read More

Paginated HTML is here and has been for some time ... I think!

We have a demo environment in my team and of course things get a little beaten up in there. Our go to, 'here's Publisher' report was looking really bad. Data was not returning or being rendered correctly on the five templates we have for it.So, I spent about a half hour cleaning up the report; getting things working again; clearing out the rubbish. I noticed that one of the layouts when rendered in HTML was repeatedly showing a header down the screen. Oh, I know where to get...

Saturday, December 13, 2014 | BI Publisher Enterprise | Read More

Bordering Text

A tough little question appeared on one of our internal mailing lists today that piqued my interest. A customer wanted to place a border around all data fields in their BIP output. Something like this: Naturally you think of using a table, embedding the field inside a cell and turning the cell border on. That will work but will need some finessing to get the cells to stretch or shrink depending on the width of the runtime text. Then things might get a bit squirly (technical...

Tuesday, November 18, 2014 | RTF | Read More

Multi Sheet Excel Output

Im on a roll with posts. This blog can be rebuilt ... I received a question today from Camilo in Colombia asking how to achieve the following.‘What are my options to deliver excel files with multiple sheets? I know we can split 1 report in multiple sheets in with the BIP Advanced Options, but what if I want to have 1 report / sheet? Where each report in each sheet has a independent data model ….’ Well, its not going to be easy if you have to havecompletely separate data models...

Thursday, October 2, 2014 | BI Publisher Enterprise | Read More

Database Links

Yeah, its been a while, moving on ... I got a question a week back asking about how BI Publisher could handle dblinks. The customer currently has db links from DB1 to DB2 and uses them in their queries. Could BIP handle the syntax and pass it on to the database in its SQL or could it handle the link another way? select e1.emp_name, e1.emp_id,e2.managerfrom emps e1, emps@db2 e2where e1.manager_id = e2.id Well, there is the obvious way to create the join in BIP. Just get rid of...

Thursday, September 25, 2014 | Data Extraction | Read More

Internal Links

Another great question today, this time, from friend and colleague, Jerry the master house re-fitter. I think we are competing on who can completely rip and replace their entire house in the shortest time on their own. Every conversation we have starts with 'so what are you working on?' He's in the midst of a kitchen re-fit, Im finishing off odds and ends before I re-build our stair well and start work on my hidden man cave under said stairs. Anyhoo, his question! Can you...

Thursday, March 6, 2014 | RTF | Read More

Waterfall Charts

Great question came through the ether from Holger on waterfall charts last night. "I know that Answers supports waterfall charts and BI Publisher does not. Do you have a different solution approach for waterfall charts with BI Publisher (perhaps stacked bars with white areas)? Maybe you have already implemented something similar in the past and you can send me an example." I didnt have one to hand, but I do now. Little known fact, the Publisher chart engine is based on the...

Saturday, March 1, 2014 | BI Publisher Enterprise | Read More

Wildcard Filtering continued

I wrote up a method for using wildcard filtering in your layouts a while back here. I spotted a followup question on that blog post last week and thought I would try and address it using another wildcard method.  I want to use the bi publisher to look for several conditions using a wild card. For example if I was sql it would look like this: if name in ('%Wst','%Grt') How can I utilize bi publisher to look for the same conditions. This, in XPATH speak is an OR condition and we...

Monday, February 24, 2014 | BI Publisher Enterprise | Read More

Filtered Charts

A customer question this week regarding filtering a chart. They have a report with a bunch of criteria with monetary values but, rather than show all of the criteria in a pie chart, they just want to show a few. For example:  This ...  rather than this  There are a couple of ways to tackle this: 1. Filter the chart data in the chart definition. Using an XPATH expression you can filter out all of the criteria you do not want to see. Open the chart definition and update the...

Tuesday, February 11, 2014 | Charting | Read More

Alternate Tray Printing

Since we introduced support for check printing PCL escape sequences in 11.1.1.7 i.e. being able to set the micr font or change the print cartridge to the magnetic ink for that string. I have wanted to test out other PCL commands, particularly, changing print trays. Say you have letter headed paper or pre-printed or colored paper in tray 2 but only want to use it for the first page or specific or for a separator page, the rest can come out of plain ol Tray 1 with its copier...

Monday, February 10, 2014 | BI Publisher Enterprise | Read More

Memory Guard

Happy New ... err .. Chinese Year! Yeah, its been a while, its also been danged busy and we're only in February, just! A question came up on one of our internal mailing lists concerning out of memory errors. Pieter, support guru extraordinaire jumped on it with reference to a support note covering the relatively new 'BI Publisher Memory Guard'. Sounds grand eh? As many a BIP user knows, at BIP's heart lives an XSLT engine. XSLT engines are notoriously memory hungry. Oracle's...

Monday, February 3, 2014 | BI Publisher Enterprise | Read More

FSG Reporting and BIP

This is a great overview of the Financial Statement Generator (FSG) engine from GL in EBS and how Publisher fits into the picture.Thanks to Helle Hellings on the Financials PM team.

Friday, December 20, 2013 | E Business Suite | Read More

Conditional Borders

How can you conditionally turn cells borders on and off in Publishers RTF/XSLFO templates? With a little digging you'll find what appears to be the appropriate attributes to update in your template. You would logically come up with using the various border styling options: border-top|bottom|left|right-widthborder-top|bottom|left|right-styleborder-top|bottom|left|right-color Buuuut, that doesnt work. Updating them individually does not make a difference to the output. Not sure...

Monday, November 25, 2013 | Templates | Read More

Desktop Testing XSL

Bit of a corner case this week but I wanted to park this as much for my reference as yours. Need to be able to test a pure XSL template against some sample data? Thats an XSL template that is going to generate HTML, Text or HTML. The Template Viewer app in the BI Publisher Desktop group does not offer that as an option. It does offer XSL-FO proccesing thou. A few minutes digging around in the java libraries and I came up with a command line solution that is easy to set up and...

Friday, November 22, 2013 | XSL/XPATH | Read More

Comb Over

Being some what follicly challenged, and to my wife's utter relief, the comb over is not something I have ever considered. The title is a tenuous reference to a formatting feature that Adobe offers in their PDF documents. The comb provides the ability to equally space a string of characters on a pre-defined form layout so that it fits neatly in the area. See the numbers above are being spaced correctly. Its not a function of the font but a property of the form field. For the...

Tuesday, November 5, 2013 | PDF | Read More

BIP 11g Dynamic SQL

Back in the 10g release, if you wanted something beyond the standard query for your report extract; you needed to break out your favorite text editor. You gotta love 'vi' and hate emacs, am I right? And get to building a data template, they were/are lovely to write, such fun ... not! Its not fun writing them by hand but, you do get to do some cool stuff around the data extract including dynamic SQL. By that I mean the ability to add content dynamically to your your query at...

Thursday, October 24, 2013 | Delivery | Read More

Mobile App Designer

Back in August a new Oracle mobile solution jumped out of the gate, the Mobile App Designer (MAD). I seem to have been on the road every week for the last, goodness knows how many weeks. I have finally found some time this week to get down and work with it. Its pretty cool and above all, its capable of providing a mobile platform independent reporting solution. But you already have a mobile application! Yep, and I think they both sit quite comfortably together. The Oracle BI...

Thursday, October 10, 2013 | BI Publisher Enterprise | Read More

BI Publisher Trial Edition News

Whoooo hoooo! Theres finally a new version of the BI Publisher Trial Edition available for download from OTN. http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html 11.1.1.7.1 is the imaginative release name. Nevermind your iOS7's get some blazingly fast BIP '.7.1'! I'll be digging into some of the new features in the coming weeks!

Wednesday, September 18, 2013 | BI Publisher Enterprise | Read More

Siebel BIP Tuning

Another brain dump from John, the product manager for the Siebel-BIP integration. These docs focus on the out of the box integration. Where Siebel holds the reins and just sends the BI Publiser server publishing requests. For this you use Integration Objects to generate the data. This support doc contains a white paper on performance testing of the IOs and provides some standard tests that you can compare your system to. Siebel CRM BI Publisher Integration Performance[Article...

Wednesday, August 7, 2013 | Siebel | Read More

Minning and Maxing in Pivots

A tricksy question from a hobbiteses this past week or so. How can I use minimum or maximum in an RTF template pivot table? Using the pivot table dialog box, you get sum or count. So, how to get a min or max? You need to understand the pivot structure a bit to understand how to get the min|max. I wrote about the pivot table format a few years back here.  Its the C field that holds the calculation as the last parameter.<?crosstab:c8949;"//G_1";"DEPARTMENT_NAME{,o=a,t=t}";"HIRE_YE...

Monday, July 15, 2013 | RTF | Read More

Siebel BIP Integration

This post is more of a bookmark for me so that I stop bugging the brown stuff out of the John the Siebel-BIP product manager. I have had multiple customers over the past two weeks asking for help around the integration. What's its capable of? How can I allow my users to click a button to run a BIP report? How can I kick off a report from a Siebel workflow? Start right here - this is a great white paper explaining whats now available with the integration using, the Siebel...

Wednesday, July 3, 2013 | BI Publisher Enterprise | Read More

Working the Chart Percentages

Charting in BIP is such fun, well sometimes it is. Not so much today, at least not for Ron in San Diego. He needed a horizontal bar chart showing values plotted for various test areas with value labels at the end of the bars. Simple enough right? The wrinkle, they were percentage values so he needed to see '56%' not '56'! Still, it should be simple enough but the percentage formatting has a requirement for your values to be in a decimal format i.e. 0.56 not 56.0. 56.0 gets...

Tuesday, July 2, 2013 | RTF | Read More

Integrating BI Publisher and Forms 11g via web services

A freshly updated white paper on how to integrate BI Publisher 11g reports into an Oracle Forms 11g application is now available from the BI Publisher OTN page along with sample code and a video: Integrating BI Publisher with Oracle Forms | Download Sample Code | Video  Thanks to Axel and Florin from PITSS and Juergen and Rainer from Oracle Germany

Tuesday, June 4, 2013 | Integration | Read More

BI Publisher 11g Training - Jul 1-3

For those of you still sitting on the 10g fence ... or if you're new to Publisher 11g, take advantage of this educational opportunity: Oracle BI Publisher 11g R1: Fundamentals Learn To:     Create data models by using the Data Model Editor.     Create BI Publisher reports based on data models.     Create report layouts by using the Layout Editor (online).     Create reports based on OBI EE data sources.     Publish the reports on OBI EE Dashboards.    Schedule reports and...

Thursday, May 23, 2013 | Newbies | Read More

Building on Subject Areas

The new release of BI Publisher 11.1.1.7 has a very nice new feature for those of you wanting to build reports on top of the BI Server data model. In previous releases you would need to either write the logical sql yourself or build an Answer request and copy the SQL from the Advanced tab and paste it into the BIP data modeler. With the new release comes the ability to create reports without the need for a data model at all. You have the option when creating a new report to...

Friday, May 10, 2013 | BI Publisher Enterprise | Read More

Get yourself Organized!

A request from Leslie today to help her out on the user docs. In them we state that we support the MSWord organization charts but we do not give any detail. Use the organization chart functionality in the templates and the chart that is rendered in the output. Figure 4-18 shows an example of an organization chart. Figure 4-18 Sample Organization Chart Its been a  while since I have looked at them but we mean just that. You build an org chart with names in the boxes, BIP...

Thursday, May 2, 2013 | RTF | Read More

Variable Numbers to Words

Satyender posted a comment to the Numbers to Words post asking: How can I store the result of &lt;?xdofx:to_check_number(TOTAL_INV_AMOUNT,'USD','CASE_UPPER','DECIMAL_STYLE_WORDS')?&gt; inside a variable. Checking this out, BIP chokes on the assigning to the variable with a nice error:  Namespace prefix 'xdofx' used but not declared Turning to BIP RTF template guru in residence Hok-Min, he suggested avoiding the xdofx: wrapper altogether in this case and calling the function...

Thursday, April 11, 2013 | RTF | Read More

E-Business Suite 12 - XML Publisher enabled reports

With some help from the EBS folks, I recently re-ran a report on the latest EBS environment that stores the seeded content that we ship to customers. The document here (sorry,I had to zip it), lists the reports and their publisher templates. The vast majority are still based on an Oracle Reports extract rather than a publisher extract. I can not say that 100% of the reports have a Publisher template but its close. Hopefully it'll be a useful reference. For more information on...

Tuesday, February 26, 2013 | E Business Suite | Read More

Beat the Post-Holiday Blues with a dose of BIWA

You know its coming so why not plan ahead.  Come and join like minded professionals at the BIWA Summit 2013 Early Bird Registration ends December 14th for BIWA Summit 2013. This event, focused on Business Intelligence, Data Warehousing and Analytics, is hosted by the BIWA SIG of the IOUG on January 9 and 10, at the Hotel Sofitel, near Oracle headquarters in Redwood City, California. Be sure to check out the many featured speakers, including Oracle executivesBalaji...

Friday, December 14, 2012 | BIEE | Read More

All hail the Excel Queen

An excellent question this past week from dear ol Blighty; actually from Brian at Nextgen Clearing Ltd in the big smoke (London). Brian was developing an excel template and wanted to be able to reference the data fields multiple times inside the Excel template. Damn good question and I of course has some wacky solutions, from macros and cell referencing in Excel to pre-processing the data with an XSL stylesheet to copy the data multiple times so it could be referenced...

Thursday, December 13, 2012 | Excel | Read More

Interesting fact #123423

Question from a customer on an internal mailing list this, succintly answered by RTF Template God, Hok-Min Q: Whats the upper limit for a sum calculation in terms of the largest number BIP can handle? A: Internally, XSL-T processor uses double precession.  Therefore the upper limit and precision will be same as double (IEEE 754 double-precision binary floating-point format, binary64). Approximately 16 significant decimal digits, max is 1.7976931348623157 x 10308 . So, now you...

Tuesday, December 4, 2012 | BI Publisher Enterprise | Read More

Spring Cleaning

I recently got a shiny new laptop; moving my shiz from old to new, was not the nightmare it used to be. I have gotten into the habit of using a second hard drive in the media bay where the CDROM normally sits. That drive contains my life's work with BIP. I can pull it out and plug it into another machine very easily. I have been sorting through some old directories and files, archiving some, sharing others with colleagues. For instance, a little dated but if you were looking...

Thursday, November 29, 2012 | RTF | Read More

Chart Filtering

Interesting question from a colleague this week. Can you add a filter to a chart to just show a specific set of data? In an RTF template, you need to do a little finagling in the chart definition. In an online template, a couple of clicks and you're done. RTF Build your chart as you would normally to include all the data to start with. Now flip to the Advanced tab to see the code behind the chart. Its not very pretty but with a little effort you can get it looking a little more...

Wednesday, November 14, 2012 | Charting | Read More

OpenWorld Presentations and Anatomy of an RTF Template w/ files

For those who missed it ... or those who made it and couldn't get enough, check out the presentations delivered at OpenWorld: Overview and Roadmap The Reporting Platform for Oracle Applications Best Practices and even though it wasn't presented at OpenWorld an updated version of Anatomy of an RTF Template to include documented example files  (RTF template, Sub-Template and sample XML data) so you can re-use and play with the code directly.  Huge thanks to Tim and Hok-Min who...

Tuesday, October 30, 2012 | Templates | Read More

BI Publisher at OpenWorld 2012

For those going to OpenWorld, hope you can join us for any of the following Sessions, Hands On Labs or just stop by and visit us in the DEMOgrounds: Moscone South S-262 Oracle Business Intelligence Publisher Overview, What’s New, and What’s Planned Monday, 1-Oct 13:45 - 14:45 Moscone South - 305 Mike Donohue - Oracle with Ed Farler - CSC Oracle Business Intelligence Publisher: Reporting for Oracle Applications Wednesday, 3-Oct 11:45 - 12:45 Palace Hotel - RoseMike Donohue -...

Friday, September 28, 2012 | General | Read More

Quick Quips on QR Codes

Yes, I'm an alliterating all-star; I missed my calling as a newspaper headline writer. I have recently received questions from several folks on support for QR codes. You know them they are everywhere you look, even here! How does Publisher handle QR codes then? In theory, exactly the same way we handle any other 2D barcode font. We need the font file, a mapping entry and an encoding class. With those three pieces we can embed QR codes into any output. To test the theory, I went...

Friday, September 28, 2012 | Barcoding | Read More

Barcodes and Bugs

A great mail from Mike at Browning last week. He has been through the ringer getting his BIP barcoding sorted out but he's now out of the woods. Here's the final result. By way of explanation, an excerpt from Mike's email:   This is an example of the GS1_128 carton shipping labels we are now producing with BIP in our web application for our vendors who drop ship products to our dealers.It produces 4 labels per printed page, in PDF format, on peel & stick label paper. Each label...

Thursday, September 20, 2012 | Barcoding | Read More

Ubiquitous BIP

The last number I heard from Mike and the PM team was that BIP is now embedded in more than 40 oracle products. That's a lot of products to keep track of and to help out with new releases, etc. Its interesting to see how internal Oracle product groups have integrated BIP into their products. Just as you might integrate BIP they have had to make a choice about how to integrate. 1. Library level - BIP is a pure java app and at the bottom of the architecture are a group of java...

Tuesday, September 18, 2012 | BI Publisher Enterprise | Read More

Linking to BIP reports from BIEE Analyses

Bryan found a great blog post from Fiston over on the OBIEEStuff blog. It covers the ability to link to a BIP report from a BIEE analyses report with the ability to pass parameters to it. I have doubled checked and you need to be on OBIEE 11.1.1.5 to see the 'Shared Report Link' mentioned in Fiston's post when you open a BIP report from the /analytics side of the house. Enjoy! OBIEE to BIP trick

Monday, September 17, 2012 | BIEE | Read More

Dynamic Bursting ... no really!

If any of you have seen me or my colleagues present BI Publisher to you then we have hopefully mentioned 'bursting.' You may have even seen a demo where we talk about being able to take a batch of data, say invoices. Then split them by some criteria, say customer id; format them with a template; generate the output and then deliver the documents to the recipients with a click. We and especially I, always say this can be completely dynamic! By this I mean, that you could store...

Thursday, September 13, 2012 | BI Publisher Enterprise | Read More

Hey, Wheres your field?

I have finally been getting back to playing with Publisher this past week and actually building demos! I came across a nice feature in the online template builder. I had been tweaking the data model of an already built report including an existing online template. I finished my data model changes and re-opened the online template to make changes and got this: Nice! It recognized that some of the fields were now missing from the data model and was asking me to map new fields...

Tuesday, September 11, 2012 | BI Publisher Enterprise | Read More

Trigger Happy

Its been a while, I know, we’ll say no more OK? I’ll just write …In the latest BIP 11.1.1.6 release and if I’m really honest; the release before this (we'll call it dot 5 for brevity.) The boys and gals in the engine room have been real busy enhancing BIP with some new functionality. Those of you that use the scheduling engine in OBIEE may already know and use the ‘conditional scheduling’ feature. This allows you to be more intelligent about what reports get run and sent to...

Wednesday, September 5, 2012 | BI Publisher Enterprise | Read More

14540059 - UPDATE FOR BI PUBLISHER ENTERPRISE 11.1.1.6.0 AUGUST

Its been a while, I know :( I have posts in the pipe just gotta smoke em out! The latest update for BIP 11.1.1.6 was released last week. A bunch of defects have been addressed as you can see below.  13473493 - XMLP TRANSLATION ISSUE OF MILLION (ENG) TO MILLIONES (SPANISH)  13521951 - BIP UPGRADE FROM 10G TO 11.1.1.5.0 IS NOT SUCCESSFULL FOR TIAA-CREF  12542914 - ACC: REPORT VIEWER STRUCTURE HAS ERRORS - NO IFRAME AND NO LANG ATTRIBUTE 13562801 - XML TAG DISPLAY SHOULD DEFAULT...

Tuesday, September 4, 2012 | BI Publisher Enterprise | Read More

EBS Customers Please Read

There's an urgent update from Steven Chan over on the EBS Apps blog that you need to check out! URGENT BULLETIN: Disable JRE Auto-Update for All E-Business Suite End-Users

Wednesday, June 13, 2012 | E Business Suite | Read More

Secrets Revealed to Advanced Charting

We get a lot of emails and questions here at Publisher Tower concerning charts and how to do X. I write about some of the solutions here if I think they could be useful to a wider audience but its tough to document everything for everyone's specific features. The chart dialog in the template builder gets you so far but there are cases where you are going to have to get into the code to make things work the way you want them to. I have documented a bunch which I have pulled...

Friday, May 18, 2012 | BI Publisher Enterprise | Read More

Collaborate 2012 wrap up - A Few Presentations Worth a Second Look

It's been a few weeks and hopefully everyone is fully recovered.  Here are a few presentations that really stood out.  No offense to any not mentioned, there were too many to attend and describe here. Adam Crigger of Preferred Strategies presented "Using Oracle BI Publisher for JD Edwards Operations and Financial Reporting" He unveiled some fabulous layouts he built using BI Publisher 11.1.1.6 on top of JD Edwards EnterpriseOne data.John Peters of JRP JR, Inc showed us some...

Tuesday, May 15, 2012 | Applications | Read More

Beyond the Conditional Dialog

Interesting question today, asking how to conditionally underline and align text in an RTF template? Your first thought, the conditional dialog box in the Template Builder for Word right?Mine too, but I know that the dialog is limited to setting the background color, font color and font style. However, the XSLFO standard has a bunch of attributes that can be set. There is going to an intersect of what the standard offers and what BI Publisher has implemented. Ots also going...

Friday, May 11, 2012 | RTF | Read More

Port 80 Goodness for Publisher

Do you ever tire of remembering what port BIP is running on when you enter the URL? Ever wish you could just type: http://tdexter-lap/xmlpserver and be done with it? Well its really not that hard to do. Its documented how to front the web logic server with a web server whether that be Microsoft's IIS or maybe Apache. Well with my success at getting BIP on to my Ubuntu laptop I thought I would give Apache a whirl being as I dont think IIS would run on my machine :) I did start...

Tuesday, May 8, 2012 | BI Publisher Enterprise | Read More

Running BIP on Ubuntu!

I am a complete Ubuntu (Linux) convert ... my work laptop runs 64 bit Ubuntu and Im very happy with it. Yes I do still need windblows for a few things and for testing but I would say 80-90% of my time is spent in Ubuntu. Not so good is Oracle's support for Ubuntu, some of that I guess, is around Ubuntu being seen primarily for the desktop and not for servers and also Ubuntu's interesting at times, implementation of Linux. Case in point, the recent release of the BI Publisher...

Monday, May 7, 2012 | BI Publisher Enterprise | Read More

Conversion Experience

On the heels of the great new, lightweight Trial Edition we are also happy to help you get to a better reporting experience. Please visit our Conversion Center where you can find loads of good information on how to convert from Crystal, Actuate or Oracle Reports to BI Publisher.  You'll find planning guidance, tools, best practices and pointers to Oracle Consulting and Partners if you want a personal guide to a higher reporting plane.

Thursday, May 3, 2012 | Migration | Read More

Proxy Images in EBS

Gareth Roberts, founder of Virtuate, a consulting outfit based in New Zealand, came up with a doh! moment for me this week. He has been working with Publisher and trying to get images into his reports that are sitting behind a proxy server. This is all inside E Business Suite so no means to use the JVM proxy settings when the concurrent manager starts up. The support folks found the solution that I had completely forgotten about ... I have been away from EBS too long :( When...

Thursday, May 3, 2012 | E Business Suite | Read More

BI Publisher has hit the gym

As Pieter reminded me this morning a sleek, slim, new installer is available for BIP 11g. The Oracle BI Publisher 11g Trial Edition hasbeen released on OTN. In comparison to the fatty monster that is, OBIEE Suite, tipping the scales at more than 7Gb; BIP Trial Ed is a svelte, muscular beauty a tad under 600 Mb. A fully functional, free server provided for evaluation purposes. It is not intended for production deployments thou. For that you have to go start the BIEE download...

Wednesday, May 2, 2012 | BI Publisher Enterprise | Read More

Fusion Middleware Innovation Awards 2012

Is your organization using Oracle BI  to deliver unique business value? If so, submit a nomination today for the Oracle Fusion Middleware Innovation Awards. These awards honor customers for their cutting-edge solutions using Oracle Fusion Middleware. Winners are selected based on the uniqueness of their business case, business benefits, level of impact relative to the size of the organization, complexity and magnitude of implementation, and the originality ofarchitecture. The...

Tuesday, May 1, 2012 | BI Publisher Enterprise | Read More

Macro Can not be Found Error

There have been messages on the forum and via email in the past few weeks about an issue that occurs with MS Word Template Builder. It appears that the latest MSOffice patch breaks all versions of the Template Builder prior to 11.1.1.6. You'll get an error similar to:  'The macro cannot be found or has been disabled' It actually appears to not only break our plugin but any VBA based code that might be embedded inside MSWord. Rather than re-regurgitate the current work around...

Thursday, April 26, 2012 | Templates | Read More

Collaborate 2012 update - additional Hands On Lab sessions

Hello Collaborators. Great first 2 days at Collaborate.  On Sunday saw Anthony Isele from McKesson tell a wonderful success story on how they converted critical contracts from Actuate to BI Publisher within Siebel CRM - A Case Study of a Migration to BI Publisher From Actuate at a Leading Healthcare Company.  Earlier Mark Andrezjewski and Shawn Scanlon touted the benefits of the Oracle Red Stack for JD Edwards EnterpriseOne customers - I Bleed Red, Oracle Red Stack that Is... B...

Tuesday, April 24, 2012 | Applications | Read More

BI Publisher at Collaborate 2012

Wow - There are over 30 fantastic presentations that cover BI Publisher at Collaborate this year.  Interest and use of BI Publisher continues to spread across the growing family of Oracle Applications and products. See Focus On BI Publisher at Collaborate 2012 for a day by day view of all the sessions. Come and visit us at the Oracle Business Intelligence Foundation demo station (kiosk 14) to chat and see BI Publisher 11g live.If you want to try BI Publisher 11g, show up for...

Wednesday, April 18, 2012 | Applications | Read More

All things Siebel

John from the Siebel product management team just shared a neat list of resources for all things Siebel-BIP. Too good to park in my email folders, here it is for everyone. OpenWorld presentations: http://www.oracle.com/us/rednetwork/index.html 2010 - Siebel Reporting: Oracle Business Intelligence Publisher Customer Experiences 2011 - Building More Insightful Reports with Siebel CRM Reporting Solutions BI Publisher forum (public) http://forums.oracle.com/forums/forum.jspa?forumID=24...

Wednesday, April 18, 2012 | Siebel | Read More

Oracle OpenWorld 2012 Call For Papers Ends Monday 9-April at Midnight

September 30th seems a long way off now but the window of opportunity for a free pass to Oracle Open World is closing fast. Act now to share your BI Publisher success story with others and demonstrate your mastery and expertise. I know some of you are experts and it would be great for you to share what you know. Now is the time to submit your presentation abstract for review by the selection panel. The competition is strong: roughly 18% of entries are accepted each year from...

Friday, April 6, 2012 | Read More

Updating a database connection password using a script

An interesting customer requirement that I thought was worthy of sharing today. Thanks to James for the requirement and Bryan for the proposed solution and me for testing the solution and proving it works :0) A customers implementation of Sarbanes Oxley requires them to change all database account passwords every 90 days. This is scripted leveraging shell scripts today for most of their environments. But how can they manage the BI Publisher connections?Now, the customer is...

Friday, March 23, 2012 | BI Publisher Enterprise | Read More

Advanced Charts Part I

Yeeeep! Another series looms ... this one could stretch out a bit and more options become available. Ever needed to generate something similar to these? Beyond what BIP can provide today but there are a few options; one from Oracle and R, now out in the wild and another out there from JFreeChart, open source and therefore almost free. Of course Google is ever present and they have been extending their chart support. I blogged the How for Google charts a while back here....

Monday, March 19, 2012 | BI Publisher Enterprise | Read More

Conditional Charting II

A follow up post on yesterdays efforts. After pinging a few colleagues Klaus came up with a much much neater approach that appeals to my sense of easy, straightforward and neat, when it comes to code anyway. A by product of the approach, it can handle, none, one or multiple conditonal bars. So, no variables ... a big plus, some chart xml editing, not quite so good but the benefits far outweigh the costs. Its a case of digging into the chart code and maybe Klaus (who is...

Wednesday, February 29, 2012 | RTF | Read More

Conditional Charting

Something I have never been asked for with BIP until recently, conditional charts. Not whether they appear or not but being able to highlight a specific bar on a bar chart if it meets some certain criteria. The chart to the right is simple enough showing sales by month. The April bar is being highlighted in red because the value is falling outside of some limit. So how can you do it? Its not documented in the BIP docs, it's not in the BIBeans (charting engine) docs, so until I...

Tuesday, February 28, 2012 | RTF | Read More

11.1.1.6 is out ...

I know, I'm a day or two late ... blame my travel schedule. Get 11.1.1.6 here. Some highlights Improved Create Report Flow - really neat UI to walk you through the report creation process. Old pros dont worry you can circumvent it. Enhancements to Parameter Display Options Support for radio button and check box display of values New options for placement of parameters in the report viewer New report viewer toolbar button to show or hide parameters Search added to menus Option to...

Wednesday, February 22, 2012 | BI Publisher Enterprise | Read More

Rocky Mountain User Group Preso

For those of you that could not make the Rocky Mountain User Group session yesterday. Nikos, from the product management team has kindly loaded my presentation and the sample templates I showed, up to OTN. Its a bit of a monster so be patient. http://www.oracle.com/technetwork/middleware/bi-publisher/beyondthelistingreport-1526340.zip Its worth 'running' the powerpoint for the fantastic comedic moments we shared in the room, well, kinda. You need my deep southern Louisiana...

Friday, February 17, 2012 | Templates | Read More

Debugging BIP ... its getting easier

Long time friend of BIP and bippers everywhere, Ike Wiggins, has worked on and shared another nugget of BIP gold. An easier way to set up debugging on your RTF templates while previewing output using the MSWord plugin. No more deploying your template to test and debug; do it from the comfort of an armchair with a glass of your favorite tipple ... alright, it's not that easy, but a lot easier. Head on over to Ike's little ol place on the net and find out the 'how' -  http://bipu...

Tuesday, February 14, 2012 | BI Publisher Enterprise | Read More

Get thee to University!

Friends of BIP, STR Software have put together a great web based resource 'BIP University' Focused on  the E Business Suite flavor and their own integrations with BIP under EBS R12; its a great resource and well worth a few clicks and a read. Check it out here - http://www.bipuniversity.com/

Wednesday, February 1, 2012 | E Business Suite | Read More

Oracle Policy Automation and BI Publisher

Yep, found another integration with BIP. I get asked about Oracle Policy Automation quite a lot; I do not profess to know much; enough to be dangerous I guess. However, I was not aware that they had been working with BIP to help automate the generation of documents from the system. For the uninitiated, here's the blurb care of : Oracle Policy Modeling is a Windows desktop application for transforming legislation and policy documents into executable businessrules. Rules are...

Saturday, January 28, 2012 | BI Publisher Enterprise | Read More

BI Publisher January patch for 11.1.1.5.0

The BI Publisher January patch for 11.1.1.5.0 is now available on Metalink; look for patch 13554951. Thanks to Shinji and team, this is one of the easiest posts of the year so far :0) Contents of the readme below, enjoy! One-off patch for Oracle Business Intelligence Publisher 11.1.1.5.0 READ ME File ================================================== This patch contains fixes of following bugs for Oracle Business Intelligence Publisher 11.1.1.5.0. 9102877 - QA: QUERY BUILDER...

Monday, January 9, 2012 | APEX | Read More

Siebel Tips and Tricks

Good tidings for the season to all of you. Its been erratic I know but we have stumbled along this year ... I have been working with Eric, a Siebel sales consultant whiz on the BIP integration. He shared some really useful tips with a Siebel-BIP customer yesterday which I thought were well worth sharing. Date Formatting Firstly, some help with formatting dates when you are using a Siebel integration objects to generate the data. Siebel IOs do not generate the XSD date format...

Friday, December 23, 2011 | BI Publisher Enterprise | Read More

Excel 2007 Warnings!

As many of you have found out, everything is not as it seems with the Excel output that gets generated from an RTF template. It has non-Excel like limitations and the files are quite big. Those of you using Excel 2007 will have noticed another niggle. When you open an 'Excel' output you get a warning along the lines of: The file you are trying to open, '*.XLS', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a...

Wednesday, December 7, 2011 | Excel | Read More

11.1.1.5 December 2011 Update Available

Latest and greatest from the boys and girls at the coal face for December. Bug fixes and some interesting enhancements that I hope to dig into to here soon. Search for patch 13366758: UPDATE FOR BI PUBLISHER ENTERPRISE 11.1.1.5.0 DECEMBER 2011 on Oracle Support. Make sure you check out the readme for patch installation instructions. 9102877 - QA: QUERY BUILDER GENERATES INCORRECT SQL FOR MANY DBS 10402890 - SETTINGS FROM "DELIVERY CONFIGURATION" PAGE NOT BEING HONORED WHEN...

Tuesday, December 6, 2011 | BI Publisher Enterprise | Read More

Dynamic Content using Sub Templates

I have written about sub templates in the past on a few occasions; the principle behind them is pretty simple. If you have common report components that can be shared across reports; be they blocks of text like standard contract clauses or maybe some common calculation or function, drop them into a sub template and share the love. Develop once, use everywhere!A colleague was recently tasked with conditionally bringing into a report output, paragraphs of static text based on...

Thursday, December 1, 2011 | Templates | Read More

UPDATE FOR BI PUBLISHER ENTERPRISE 10.1.3.4.2 NOVEMBER 2011

It's Friday, that means its patch release time. Why do we do this to ourselves, 'we'll release on Friday!' It might 11.59 on Friday but by golly we'll have released on Friday. I can remember a release of BIP years ago that for some reason we went for 12/31 as a release date ... were we mad? I seem to remember we made it but talk about ridiculous pressure! The latest 10g rollup is out in the wild and available from Oracle support. A bug fixing rollup but worth getting to and...

Friday, November 18, 2011 | BI Publisher Enterprise | Read More

Time for a Timeout

Couple of inquiries this week around the default timeout for BIP 11g installs and being able to change it. Its not currently documented (Leslie is working on that :) and when you see what you need to do you might understand why. It's ugly, very ugly but in the interest of getting the information out there, here we go. The BIP session timeout is controlled in a section in the web.xml file under the WEB-INF directory. <session-config>  <session-timeout>30</session-timeout></sessio...

Thursday, October 27, 2011 | BI Publisher Enterprise | Read More

Tricky Grouping

A week off trying to catch up with all the stuff that builds up was not enough but it was pretty fruitful. You clear the decks the week before you leave, you even answer a few mails in the first few days of vacation, until your manager slaps your wrists. But there is always a pile of work waiting when you get back. It was not too bad this time; I at least deleted the crap mail during the week via my phone.How the heck did we survive without smart phones? I took a trip...

Wednesday, October 26, 2011 | RTF | Read More

Open World Presentations

The dust has finally settled at the Moscone Center. I hope everyone had a wonderful time at Open World.   For those of you who would like copies of the presentations we made, as promised, they are now available on the Publisher OTN page.  Here are direct links: Create All Your Reports More Easily and Quickly with Oracle Business Intelligence Publisher (14982) Oracle Business Intelligence Publisher: The Reporting Platform for Oracle Applications (12426) Become a...

Thursday, October 13, 2011 | General | Read More

BIP and Mapviewer Mash Up IV

Dang folks, we're on part four already, things start to get really groovy now. If you're jumping in at part four, here are the previous episodes: BIP and Mapviewer Mash Up I BIP and Mapviewer Mash Up II BIP and Mapviewer Mash Up III The current approach to get the maps into the output using encoded concatenated URL strings works but if you need to make changes to the map request call it gets fiddly and annoying quite quickly and if you need to drop another map into another...

Wednesday, October 12, 2011 | BI Publisher Enterprise | Read More

BIP and Mapviewer Mash Up III

This is the third installment of the BIP and Mapviewer Mashup, for the previous entries: BIP and Mapviewer Mash Up I BIP and Mapviewer Mash Up II BIP and Mapviewer Mash Up III Its been a hectic couple of weeks which has included all things mapviewer and integration. I have finally got my piece de resistance in mapping integration working but more on that next time. Its very cool in a geeky BIP, kinda way; my wife was completely fascinated when I told her all about it over dinner...

Monday, October 10, 2011 | RTF | Read More

BIP and Mapviewer Mash Up II

Quite some time ago now I wrote the first of what I thought were going to be at least a couple of articles on getting BIP to render maps via Oracle Mapviewer. It was a real HelloWorld example with no 'World' just the 'Hello' bit. I like to think it was like Kevin Costner's 'Waterworld', a nice idea but poorly executed and a flop at the blog box office but it would have been a perfect map for the movie. I have to admit, I think Dennis Hopper was awesome as the bad dude. Well, I...

Thursday, September 29, 2011 | RTF | Read More

BI Publisher sessions for Oracle Open World 2011

Are you coming to Oracle Open World 2011? No?  There's still time to register!  The conference starts Sunday, Oct 2nd Yes?  Great!  This year, in addition to the awesome sessions and demo pod, there are several hands on labs where you can get your hands on the product. For a list of all the sessions that will highlight BI Publisher, please check out the Focus On Business Intelligence Publisher handout. Be sure to add these sessions using the Schedule Builder, so you can be...

Tuesday, September 27, 2011 | BI Publisher Enterprise | Read More

11g September Rollup

The latest rollup patch for BIP 11.1.1.5 is available, 12954375. For your delight and delectation and to bulk out this post, I have reproduced the readme file below. This patch contains fixes of following bugs for Oracle Business Intelligence Publisher 11.1.1.5.0. 10402890 - SETTINGS FROM "DELIVERY CONFIGURATION" PAGE NOT BEING HONORED WHEN REPORTS RUN 11725468 - ER: RTE HTML SUPPORT IN DATA XML 11828672 - QA: INCORRECT INACTIVE WARNING MESSAGE 11835845 - 11G SQL DATA SET...

Monday, September 19, 2011 | BI Publisher Enterprise | Read More