For this last posting on XML Publisher I thought I'd take a look at how reports are deployed into production. The approach I've used so far - build a report template using the XML Publisher Desktop product, then preview it as a PDF - is obviously

I've recently been putting together an article for Oracle Magazine on the new DML Error Logging feature in Oracle 10gR2, which allows you to add a LOG ERRORS clause to most DML statements so that rows that would otherwise cause the statement to fail are instead copied to

Last week I posted on a JDeveloper extension for DW [https://www.rittmanmead.com/blog/2005/11/21/modelling-from-jdeveloper/] modelling tool and promised an update when I managed to get it to work. Well the guys at the IKAN have been very helpful and let me download the documentation for

I've continued looking at the Desktop element of XML Publisher today, and I've been thinking about how we get data into XML Publisher. The emphasis is on getting data from XML documents, which obviously reflects the products' heritage - XML Publisher was originally the new

I've put my name forward for doing an XML Publisher presentation at the next BIRT SIG, and as I've finished the articles I was writing I've got a chance now to start playing around with the product. Over the next few days I'

If you've got a spare twenty-five minutes, Chris Webb has an interestingpodcast featuring Nigel Pendse [http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!398.entry] up on his website at the moment.Chris [http://spaces.msn.com/members/cwebbbi/PersonalSpace.aspx] is a kind of alternate

Time for a quick update. If you read my posting a couple of weeks ago, you'll have seen that I've been working away on a few articles recently, hence the lack of updates. It's all a bit embarrasing actually as the Oracle Magazine ACE

The other day I had a rant [https://www.rittmanmead.com/blog/2005/11/07/design-matters/] about poor (in my opinion) DW design, and in particular not using the database features to the best advantage (or at all). Sometimes, though, people use the wrong features. Database links can be a

If you're a regular reader of this blog you'll probably have noticed that the frequency of postings has gone down a little over the last few months, part of this is due to our second child coming along, but it's also because I'

A few bookmarked articles that I've been meaning to clear out for a while. * A nice article from Lucas Jellema onusing DBMS_FREQUENT_ITEMSET for PL/SQL data mining [http://technology.amis.nl/blog/index.php?p=214] * Intelligent Enterprise with asneak peek to Cognos 8 [http://www.

I've been over in Ireland for the last week, and in the evenings working on a new article for OTN on data profiling using OWB "Paris", so I've not had a chance to update the blog since the UKOUG conference. In the meantime though,

Back from the UKOUG Conference now, just thought I'd jot some final thoughts down on the four days. Unlike Open World, I've actually had a job to do over the past three days so I've not had much of chance to post anything except

Only a few minutes to update the blog this morning, as I should really be doing some more prep for my talk at 10.30 in hall 5. Yesterday was spent on the stand... chairing presentations, such as this one by Sten Vesterli on PL/SQL programming ... ... attending presentations, the

Today was the day for Tom Kyte's keynote and fromreading his blog [http://tkyte.blogspot.com/2005/11/ukoug-day-2.html]just before the presentation, I had an inkling that a few of us last night were in for a bit of a ribbing. Little did I know ... See

It's Monday morning at about ten to seven, and for the first time in three years at the UKOUG, I've actually had a good night's sleep. My plan to go out on Sunday night and get trashed has obviously worked, so now it'

It's Monday morning at about ten to seven, and for the first time in three years at the UKOUG, I've actually had a good night's sleep. My plan to go out on Sunday night and get trashed has obviously worked, so now it'

Just a brief update after I've arrived up in Birmingham for the UKOUG Conference [http://conference.ukoug.org/]. I came up by train this time rather than drive, as the drive up from Brighton is on the one hand either really tedious - around the M25 then an

Just a brief update after I've arrived up in Birmingham for theUKOUG Conference [http://conference.ukoug.org/]. I came up by train this time rather than drive, as the drive up from Brighton is on the one hand either really tedious - around the M25 then an hour

Niall [http://www.niall.litchfield.dial.pipex.com/2005/10/ukoug-agenda.html] and Doug [http://oracledoug.blogspot.com/2005/10/ukoug-agenda.html] have done theirs, so I thought it's about time I put my UKOUG Conference diary up on the blog. My time over the three main days

Part 2 of my Oracle Database 10g OLAP Performance Tips & Techniques [http://www.dbazine.com/olc/olc-articles/c-rittman8] article is now online at DBAZine (part 1 can be found here [http://www.dbazine.com/olc/olc-articles/c-rittman7]). In this final article I look at the process of loading and

Part 2 of my Oracle Database 10g OLAP Performance Tips & Techniques [http://www.dbazine.com/olc/olc-articles/c-rittman8] article is now online at DBAZine (part 1 can be foundhere [http://www.dbazine.com/olc/olc-articles/c-rittman7]). In this final article I look at the process of loading and then

After I finished at university back in the early 90's, I worked for a few years at American Express in Brighton. If you've been a student in Brighton the chances are you've worked at Amex at some point (theirEuropean processing centre [http://www.pmoyer.

Yesterday my thoughts returned to the topic of time, not in the Stephen Hawkin sense but the more prosaic "Data Warehouse" sense. Three questions popped up, and although I hold firm views about the answers I think there are others out there with the opposite view and indeed