So here I am plugging in some dimensions and getting some measures in Visual Studio when I stumble on the fact that I can’t get the MDX from what I’m doing. What should I use to do this? One tool I know that will get the MDX for a report is ProClarity, but are there... Continue reading →

Thanks James, for pointing out I’m a dickhead. You saved me at least a few more minutes of troubleshooting! SqlprofileProvider is in the Profile namespace branch unlike EVERY other membership provider in ASP.NET 2.0. I guess I’ll be the 5th with the google”able” error message of ‘Could not load type ‘System.Web.Security.SqlProfileProvider’! Technorati Tags: SqlProfileProvider …... Continue reading →

As usual, the first week or three at a new position is very relaxed or at least somewhat calm. Which for me leads to a bit of boredom, but I always know that just around the corner of being the FNG (F-ing New Guy) is the fast paced action of the project work. Now that... Continue reading →

Often times there is no cube, no OLAP, no BI plan but someone wants reports that provide rollup data, data slices, sums, and even dimensional representations that are oriented toward the BI world. Of course building these in SQL is possible, even easy sometimes, but it slams the processing of an RDBMS. When working through... Continue reading →

I’ve always know there had to be some rule or logic that someone has laid out for usability. Especially from a marketing perspective. Recently I took to reading a few pages of Web Analytics Demystified by Eric T. Peterson. While reading through the book in the very first few pages the 10-second usability rule is... Continue reading →