Entries Published On March, 2013
SSAS Bug: EXCEPT with nested FILTER functions on MEMBERVALUE
Last week while spending some time on the forums, I stumbled upon a thread where the user had presented 2 queries with seemingly identical logic but produced very different results. After a bit of troubleshooting I was stumped and fired off an S.O.S. tweet with the #ssashelp hashtag. Within the hour I had received a …
Analyzing SQL Server Object Dependencies with NodeXL
One time I was tasked with developing a handful of custom reports for a legacy application. The data model was an absolute nightmare – overflowing with technical debt and being held together with duct tape and views…tons and tons of views. In this post, I’ll show you how NodeXL can be used to help navigate …
Analysis Services 2012: Tabular or Multidimensional?
If you regularly follow this blog, then chances are likely that you are already well aware of the new Tabular mode in SQL Server Analysis Services 2012. If not, don’t sweat it – we won’t be diving into anything super technical in this post 😎 Analysis Services Tabular is a new mode that I would …
Top FREE tools for SSAS 2012 Developers
Over the years, I’ve come across a number of tools aimed at helping SSAS developers work more efficiently. In this post, I’ll share with you the ones I’ve found the most useful and give you a brief explanation of why. Note: Most of these tools were released prior to Analysis Services 2012, but fortunately, aside …
How to Calculate the Median in T-SQL, MDX, and not DAX
Building from my last post, Performance Metrics: Average, Mean, Median, and Outliers, where I covered the topic of when to use Median instead of Average, in this post I’m going (to try) to show you how to calculate the Median of a set of values in T-SQL, MDX, and DAX. Calculate Median in MDX Let’s start …
Performance Metrics: Average, Mean, Median, and Outliers
This weekend, I stumbled across a post that really hit close to home. The post was written by Brad Feld, a VC whose blog I’ve subscribed to since college. Brad normally writes about startups, startup-communities, and marathons in which he participates…none of which I’m particularly interested in anymore. But in this particular post, Revisiting Median …