Yikes! This was a looooong time ago.

For what it's worth, we used this process in more or less the format presented (in this article and the next two articles) for four years with no troubles. The application (and associated data mart) were retired last year when we converted over everything to a new system. Unfortunately, no one scoped out reporting or BI for the new system, so we're back to running direct queries on the operational database.

The more things change, the more they stay the same.

Regards,

Hugh