An Oracle blog about BI Publisher

Data Template Progression

I recently spent some time putting together a progression of data templates (DT) for a customer demo. Its a series of data templates that move you from the simple to the more complex, two query, before fetch trigger, group filter, summarizing all singing all dancing data template. I have heard requests this week for a three'er - looking at that. For now, satisfy yourselves with what I have.

Yep, still no builder but the 11g data builder is so cool it makes my geeky mouth water. Can not post images for fear of product management reprisal and bats up night dresses in the small hours (go Google it :0)

In spite of the lack of a DT builder I found it quite useful and so much faster to start off with the queries, get them working and returning data based on the parameters and to then move to the grouping, group filters (please dont use em) and summary columns. Rather than trying to write the whole this in one hit and then spend forever debugging.

During the demo we discussed the error messages and means to debug that BIP offers. Some of the layout errors are still mystifying at times '1=1' and '9<10' come to mind as true but very annoying error messages. You'll be pleased to here that turning on the debug for the data templates provides a mass of information about what is going on and of course what did not happen and why.

If you're interested you can get the progression here. Just unpack them under a directory under the BIP reports home directory. Fire up BIP and they will be available. They all run against the demo HR schema in an Oracle db. There is also a sql script for the supporting plsql package for the triggers.

Finally, just because its amusing and I wanted to share the mirth, check out this funny developer 'joke' from Bex on his blog, made me chortle!

Join the discussion

Comments ( 8 )
  • Lionel Featheringham Wednesday, February 3, 2010
    Hello, great post, I thouroughly enjoyed reading this. the article gave me the kick to try my own blog, please see my article by clicking my name at the top of this article, cheers
  • Nenita Frattali Wednesday, February 17, 2010
    Online article directories have gained in reputation during the last few years. The main reason for this are various SEO related features and possibilities an article directory made available to authors and content seekers. Some of the popular articles directories allow authors to submit their work for free while some cost a small one-time registration fee. Submit your articles to a dir247 and get published within a day!
  • Casey Albair Tuesday, April 20, 2010
    I'd have to agree 100% with you that search engines do give some type of value to links whethere they be dofollow or nofollow. You may not receive any Page rank transfer over but your SERPs will still rise.
  • seo monitoring Friday, May 28, 2010
    Wonderful to read!
  • Caryn Modique Friday, June 4, 2010
    Although I don't see eye to eye with all you said, I must confess I do love your way of writing.
  • Steven Monday, June 14, 2010
    Can someone please convert the xdo files to simple text/word files and post/email them please as I can't open them.
    Many thanks,
  • Stan Boyn Sunday, August 1, 2010
    Cool concept, I will do a little more research and try to put my own spin on it.
  • Outrank.com scam Wednesday, August 18, 2010
    Excellent job.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.