The Oracle Sponge

Oracle Data Warehouse Design and Architecture

Whoops!

Posted by David Aldridge on 2006-08-17

I just realised that I made a silly error in the Year-to-date transformation table demonstration scripts. It doesn’t affect the validity of the conclusions, thank goodness, but I’ll correct it shortly.

The error was that in the select statement I should have been grouping by the date_of_sale, not the month_of_sale, so the numbers are rather meaningless as they stand. Ironic really, as I’m often lecturing people on the topic of paying attention to the dimensionality and meaning of the result sets in such situations.

Tut!

2 Responses to “Whoops!”

  1. Doug Burns Says:

    Sigh.

    You’ve destroyed my faith in you ;-)

  2. David Aldridge Says:

    Your faith in my perfection, or my ability to seemlessly hide my errors by sleight-of-hand and deception? either would be an acceptable answer :D

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>