Oracle BI Publisher Blog

Many of you know that publisher requires some 'extras' to get your document to a printer in a legible format. There are now printers that can handle the PDF format natively but the majority of printers need to have the PDf converted to either Postscript (PS) or Printer Control Language(PCL). We have recommended a couple of converters to help you out with this.

Ghostscript, offers both PS and PCL converters the other product we recommend is xpdf from foolabs and we have many of you using both products very successfully. In spite of their robustness many of you have expressed concern - 'it's another moving part in the whole document generation process' - 'and it's not owned by Oracle' -  both fair comments and I can understand the concern - however we have faith in these solutions and will help you to use them.

For BIP Standlaone users there is some good news, we have now built our own Postscript libraries to convert from PDF to PS. Very easy to use when setting up your printers in the user inteface.

As you can see its simple to use and if you want to continue to use another converter thats simple too. There are some caveats and limitations:

This release of the PDF to PostScript converter has the following limitations:

• 
  

  Only PDF version 1.4 or earlier is supported. This is also the currently supported version of the Oracle BI Publisher PDF output.

  
  
• 
  

  CID fonts, which are used mainly to support languages with large sets of glyphs like Chinese, Japanese, and Korean, are only supported when embedded in the PDF.

  
  
• 
  

  Transparent and half-tone renderings are not supported.

  
  
• 
  

  DeviceN color space is not supported.

  
  
• 
  

  Shading patterns are not fully supported.

  
  
• 
  

  Vertical writing is not supported.

Not forgetting you EBS and other apps users out there - this functionality will be coming to an application near you later this year (for EBS) and next year for others.

There was a question on our internal mailing list today on our translation methods - the answers are in the user guide but the interesting thing was a mail from another BIPper. Microsoft have released a pretty decent XML editor at last. Last time I tried it, it was not a good experience, there still seem to be some niggly issues but overall its pretty useful.

Its not a style sheet editor but if you need to do some work with XML - I seem to spend my life doing this, debugging templates, building demo XML, etc. I get to use the great but expensive, XMLSpy but considering the features I use, the MS solution is pretty good. Get it here:

http://msdn2.microsoft.com/en-us/xml/default.aspx

Here's another 'Open XML Editor' - pretty good, not quite as sophisticated as the MS offering. And another from Peter, better than the Open XML and more on a par with MS.

Of course, if you have jdeveloper installed you get an XML editor included - but if you do not have it anyway, its a bit of an overhead if all you want to do is work with XML files.

I just sat through a really nice Siebel CRM / BIP integration demo - the CRM folks have built some very nice integration with BIP in their app. There has been some migration work to move some of the more important reports from the existing Actuate formats to the BIP format that Siebel delivers to you the customer. The best piece in my mind is the integration in the user interface - you Siebel folks are used to context sensitive reports being a coulple of clicks away but for other apps customers its a great feature.

The list of reports are context sensitive to the page and the data you are currently looking at. You can also punch out to other BIP reports you have access to in the system or that have been scheduled.

If you run the report from the UI, its executed and the result returned to you in the format you desire.

You get to manage the templates and reports via a layer of Siebel interface to the BIP server just like PeopleSoft, JDE and EBS.

It's not quite yet available but will come with the 8.1. release later this year. Because of this I need to state the following:

The blog post above is intended to outline the general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle痴 products remains at the sole discretion of Oracle.

Well its that time of year again ... and I dont mean taxes. Saying that you better have got them done by the time Collaborate rolls around again this April. There are lots of opportunities to check out BIP/XMLP related content.

This year it's in my home'ish town - so rather than stare at the four walls of a non descript hotel room. I get to help my kids with their homework face to face rather than down a phone and I get sleep in my own bed every night. The drawback is I have to get my sorry backside up to Denver everyday but the upside is that there is loads to see and listen to when it comes to Publisher.
Here's what I have found so far:

I'll be digging around a bit more in coming weeks but there are some great looking sessions in there and if time allows I'll be at every one. Best laid plans and all that, it will no doubt snow and the trains will fail and I'll miss them but I'll being doing my damndest to get there. 

If you're coming, look out for me lurking at the back of sessions. Apart from mine of course, on Thursday @8.30am, the morning after the party - I'll try and not be too energetic and loud!

We had a customer issue a few weeks back ... 'really Tim, I never would have guessed' :0) Yeah, we get some issues sometimes. This was a JD Edwards customer that had developed an encoding class for a barcode. Lost? Check out the Advanced Barcode Support article. Basically, some barcodes need the data encoded, calculating stop bits and such like, prior to applying the barcode font. To support this, we allow you to create a java class that implements a Publisher interface to encode the data values. This can then be called from the RTF template layer using commands - check the user guide people!

The encoding class needs to be in the classpath on the server be it JDE, EBS or standalone - this is straightforward enough but how about being able to test on the Template Builder for Word interface?

It can be done, no support directly in the tool but with a little jiggery pokery we can get the class tested. The list of jar files that the builder will load at runtime is limited but the main one we can highjack is the xdocore.jar. You'll find it under the jlib directory under the Template Builder install directory.

You can open the jar file using something like WinZip, with it you can see the structure of the contents,

The class you developed will no doubt have a package declaration in it e.g. oracle.apps.xx.xmlp.barcode - this needs to map to the path in the jar file. To get it into the jar in the right place just get the class into the directory path on your local drive.

Then, in the case of Winzip, open the jar, then drag and drop the class and ensure the 'Use Full Path Info' option is set to get the class into the correct path that will map to your package specification.

Now, you can test to your hearts content in the comfort and relative speed of MSWord.

Starting to actually feel human again - Im amazed how 'flu' here in the US is so debilitating. I dont remember feeling this bad since I caught some 'bug' in N Africa when I spent far too long traveling when I was younger. My brain is still trying to burst out of the front of my head but the hacking cough that makes you wince, it hurts so much is not so bad. One great side effect, for my kids at least, is that my voice has almost disappeared so they really can claim they did not hear me calling them.

The error in the title is not a nice error to see! It evokes lots of questions, how much data are you processing, how complex is the template the list goes on. Now, Im not a great fan of metalink - there is a mass of useful information in their but getting at it is nigh on impossible.

I was in our Ohio office last week meeting some of our new team Noelle, Dave and Jen. Noelle had installed BIEE and BIP and was getting an error when she tried to connect - I had not seen it before, googling it brought nothing useful so it was on to Metalink. When I usually resort to metalink I try and get as specific a string as possible cos no matter what you enter you get 100s of hits. I was amazed when we entered our string in the advanced search to only get 4 hits - excellent! Then we realized that the 4 hits were nothing to do with OBIEE or BIP ... dang! Noelle ended up falling back on the age old solution - re-installing - it worked like a charm.

If you can get past the search engine on Metalink there are some real document gems. For the error mentioned in the title go to

                            Note:315477.1 : XML Report Publisher Fails With java.lang.OutOfMemoryError

Its a good solid document with some useful information. I think Pieter from the support team wrote, thanks Pieter!

Theres a new version of the Enterprise release training now available, its a 3 day instructor led course, looks pretty good if you're just starting out with BIP.

Oracle BI Publisher 10g R3: Fundamentals (Data Warehousing and Oracle Business Intelligence)

There is also the 5 day E Business Suite course being run all over the place, fancy a trip to Alaska? I hear Anchorage is a great place to visit. Alternatively pack the kids and get to Orlando, they can check out the mouse while you use your nouse!

11i Oracle XML Publisher Fundamentals (NAMER) (E-Business Suite)

There is also the PeopleSoft training course for XMLP

XML Publisher for PeopleSoft Enterprise PeopleTools Rel 8.48 (PeopleSoft Enterprise)

Its a one day affair but boy do they pack stuff in for it - I mentioned it in more detail here. You can also study from the comfort of an armchair at home using the CD-ROM option.

Last but not least is the JD Edwards  training

EnterpriseOne Embedded BI Publisher Rel 8.97 - RWC (JD Edwards EnterpriseOne)

Its a self study course rather than instructor led but again looks to be good. I have also heard rumor of hands-on labs for JDE XMLP at OpenWorld this year - more news as I get it.

All the courses are introductions to the various flavors of XMLP/BIP, I have no doubt that there will be a Siebel CRM course coming soon. But thats it, introductions to get from a 'noob' to an intermediate but no further, after that its time to hit the docs and the forums for answers. I did enquire as to the possibility of an Advanced class but its a no no ... historically they have not been worth it for OU, just could not get the numbers of folks to fill the classes.

I have talked about doing a regular 'public' session on XMLP/BIP where we can take things a bit further and look at more advanced features, case studies, etc but you guys are just too quiet - I got maybe one or two emails saying 'yes please!' - any one else out there interested?

If you cant email then get over the mix.oracle.com and click - they are currently allowing you to vote for or suggest sessions for OOW08. I have posted the idea of providing an 'Advanced Publisher Techniques' session but its currently languishing in 50-60th place - get over there and vote for it - https://mix.oracle.com/ideas/27984-advanced-techniques-for-bi-publisher

Even if we dont get to the top we can maybe do a session in the 'unconference' on some of the more advanced stuff or maybe one of you could, I'll stand at the back and clap and cheer loudly!

I mentioned the new demos that were being built a while back. We have now got enough of them to make them available. We are starting off with about 10 of them - they cover 'templating' for the most part. Its been a team effort, kudos to Noelle, Dave and Jen for putting the demos together.

There are some of the newer features we have in the Template Builder for Word, PDF template building and other tips and tricks. Its going to be a growing collection of demos over the coming weeks and months covering all things Publisher. I'll also be begging our PeopleSoft, JD Edwards and Siebel brethren for content to mount. If you have requests let us know.

You can get at the catalog here:

http://www.oracle.com/technology/products/xml-publisher/demoshelf/Shelf.html

For those that are interested in the delivery vehicle - its good ol Adobe Flex - we have to thank Ely Greenfield from Adobe and www.quietlyscheming.com for the Flex Shelf component - its a great component that we leverage to get away from the boring HTML formatted list.
Make sure you visit the catalog frequently to get the latest and greatest.