MDX offers many powerful statistical functions, however they have their limitations.  One of the things I’ve had to learn this past year is what types of statistical functions are available, and what they can and can’t do.  And when they can’t do what I want, I’ve had to come up with alternatives.
One such case of [...]

Or How I Learned to Stop Worrying and Love String Manipulation .
To kick off this blog with some real content I’m starting small.  I recently did some reporting work where I changed the main dataset queries from using a relational database to using a cube.  It sped up performance and resolved a lot [...]