A few fellow CapTechers and I recently had the opportunity to attend on-site training for LogiXML's Business Intelligence tools. While the LogiXML Info and Ad Hoc tools seem fairly comprehensive, there is still room for improvement on the development end of things.

LogiXML's two BI tools are very similar.  While the Info is more geared toward technical power users, the less powerful Ad Hoc option is more business user friendly. This seems to be fairly standard among most companies’ BI offerings and LogiXML is toeing that line fairly effectively. That said, most of our training focused on LogiXML Info and that’s where the majority of this post will focus.

In my last post, I covered how to use an unpivot transformation in SSIS.  There are, however, at least two other ways the same output can be achieved.  In addition to the built in transformation, a multicast into a union all or a script task can be used.  While all three methods produce the same dataset, the latter two are slower and one is much less efficient than the native transformation.   If you are interested in each of the three methods, continue reading; otherwise, you can jump to the results.