A common issue I see on the MSDN forums and at clients is how to reduce the number of members available in a filter to only those with data in the pivot table. This question … Continue reading Filtering a Pivot Table by a Large Dimension
In MDX, the WHERE-clause is commonly referred to as the “slicer”. This is because the criteria placed in this clause is used to “slice the cube”. Any query scoped named sets or members will be … Continue reading MDX: Slicer Override
Just before the end of 2013, I started a new project doing some heavy MDX development. During a recent code-review session with the rest of the team, one of the developers brought up an issue with … Continue reading MDX: Order of Named Sets and Calculated Members
Earlier this year, while building an SSRS report against a Cube data source, I got stuck trying to parameterize the dimension attribute on the rows axis of the dataset query. What I wanted was to … Continue reading SSRS + MDX: Dynamic Dimension Attribute on Row Axis
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 … Continue reading SSAS Bug: EXCEPT with nested FILTER functions on MEMBERVALUE
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 … Continue reading Analysis Services 2012: Tabular or Multidimensional?
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 … Continue reading Top FREE tools for SSAS 2012 Developers
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 … Continue reading How to Calculate the Median in T-SQL, MDX, and not DAX