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!


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

Posted by Lionel Featheringham on February 02, 2010 at 09:09 PM MST #

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!

Posted by Nenita Frattali on February 17, 2010 at 02:37 AM MST #

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.

Posted by Casey Albair on April 20, 2010 at 09:18 AM MDT #

Wonderful to read!

Posted by seo monitoring on May 27, 2010 at 11:25 PM MDT #

Although I don't see eye to eye with all you said, I must confess I do love your way of writing.

Posted by Caryn Modique on June 04, 2010 at 10:04 AM MDT #

hello. 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, Steven

Posted by Steven on June 14, 2010 at 01:57 AM MDT #

Cool concept, I will do a little more research and try to put my own spin on it.

Posted by Stan Boyn on August 01, 2010 at 10:34 AM MDT #

Excellent job.

Posted by scam on August 18, 2010 at 12:49 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!


« June 2016