Screenshot of MDX Studio containing my expression

Time Format on non-Date Dimensions in SSAS

I ran into a rather strange situation recently while attempting to set up some new calculated measures in an SSAS cube.  I’m still new to MDX, so I ended up chasing my tail around for a while (and crying out for help on both StackOverflow and MSDN) before I eventually tracked down the culprit and solved the issue.  Basically, I was trying to create a calculated measure, which, using a couple of date attributes from one dimension, would apply to my [Time] dimension and filter the value of a specified measure to match.  Not hard, right? Continue reading “Time Format on non-Date Dimensions in SSAS” »

10 Years of Xbox LIVE Infographic

Love them or hate them, there’s no escaping infographics these days.  They are EVERYWHERE.  Personally, I’m a fan.  I’ve always been interested in visualisation techniques and better ways to represent data visually.  After all, the human brain can process images and patterns much faster than it can text.  The best visualisations are the ones that need no explanation, while the worst are the ones that basically just overlay some text or numbers on some graphics and still make you read the content to understand what’s going on.  Even then though, I’m a sucker for a nice infographic (yes, event the overly textual ones).

Anyway, the point of this post was to show off a little infographic that I received from Xbox LIVE Rewards the other day to celebrate 10 years of Xbox LIVE, and illustrate my contribution to that: Continue reading “10 Years of Xbox LIVE Infographic” »

Screenshot of "Project Helix" on Windows 8

Microsoft’s Mobile BI “Project Helix” Unveiled

Some pretty interesting information leaked out of last week’s SharePoint Conference 2012 regarding Microsoft’s upcoming Mobile BI (Business Intelligence) solution.  There’s been surprisingly little reaction to the unveiling of the solution, apparently codenamed “Project Helix”, perhaps due to the fact that it was unveiled at a SharePoint event and not a SQL Server one.  However, courtesy of one attendee tweeting some screenshots to SSAS guru Chris Webb, this little nugget of information landed in my inbox this morning and immediately piqued my interest.  Unfortunately there’s very little information available on “Project Helix” at the moment, but from the 2 screenshots provided by attendee Just Blindbaek, there are a few things that are immediately apparent, and a couple more that can be reasonably inferred: Continue reading “Microsoft’s Mobile BI “Project Helix” Unveiled” »