Dave's Adventures in Business Intelligence

A user recently commented that outer join settings were not being properly captured by my universe compare tool. It turns out there is a very simple fix. If you have previously downloaded a copy of the tool, simply open the VBA editor and find this section of code:

aColTypes(dsCharacterColumn) = "Character"
aColTypes(dsDateColumn) = "Date"
aColTypes(dsNullColumn) = "Null"
aColTypes(dsNumericColumn) = "Numeric"
aColTypes(dsTextColumn) = "Text"
aColTypes(dsUnknownColumn) = "Unknown"

Immediately after that (or after a blank line if you prefer) add these new lines of code:

aJoinTypes(dsFullOuter) = "Full Outer"
aJoinTypes(dsNoOuter) = "No Outer"
aJoinTypes(dsOuterLeft) = "Outer Left"
aJoinTypes(dsOuterRight) = "Outer Right"

That is the missing piece that was causing the compare tool to skip recording the outer join types.

I will update the downloadable version and upload it shortly. For now, this will fix the bug.

Hello folks, I’m back after a nice break with a quick comment from our favorite curly tie engineer:

I needed a break from various things, but I should be back and blogging soon. Conference season is starting up. BI2013 was going to be first on my list, then SAPPHIRE. I had to back out of BI2013, and the jury is still out as to whether I’ll make it to SAPPHIRE/ASUG Annual Conference just yet.

I have finally started to do some serious work using the Information Design Tool, and my first blog post related to work flow differences between IDT and Universe Designer should be ready to come out shortly.

Finally, I have added a new permanent page to my side menu titled, “Donating To Dagira.” Please check it out and see if it’s something you would be willing to support, thanks!

I am way behind on approving comments. 😳 I will be working through those this week.