In a recent post, I mentioned something called Super DAX without giving it a very detailed explanation. If you’ve been working with SSAS for a few years and have a couple of Tabular projects under … Continue reading What is Super DAX?
SSAS Multidimensional and Super DAX
An interesting question came up during a recent engagement involving Power BI reporting against a Multidimensional data source. The client wanted to know if there was any benefit for them in upgrading from SSAS 2014 … Continue reading SSAS Multidimensional and Super DAX
Engaging the Formula Engine Cache with SSAS Tabular
One of the more subtle architectural differences between tabular and multidimensional instances is caching. Multidimensional is a disk-based technology and performance for query workloads (in many cases) depends heavily on cache utilization. Tabular, on the other hand, is … Continue reading Engaging the Formula Engine Cache with SSAS Tabular
Implementing Logical AND on Members From Same Hierarchy
The default behavior when filtering on multiple members from the same attribute hierarchy is a logical OR. In the pivot table above, we have the [Internet Customer Count] measure (which is a distinct count measure) … Continue reading Implementing Logical AND on Members From Same Hierarchy
SSAS Tabular, Telerik, Multi-Value Parameters with DAX
Earlier this summer, I started working with a new client to develop the next version of their reporting platform. This client already had the reporting requirements and good jump start on the underlying data model but … Continue reading SSAS Tabular, Telerik, Multi-Value Parameters with DAX
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 … Continue reading Analysis Services 2012: Tabular or Multidimensional?
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 … Continue reading Top FREE tools for SSAS 2012 Developers
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 … Continue reading How to Calculate the Median in T-SQL, MDX, and not DAX
Is it possible to circumvent role-based row-level security with a well-crafted DAX query?
Recently, while discussing role-based security in SSAS Tabular models with a few colleagues, the following question came up: Is it possible to write a DAX query in such a way that row-level security is bypassed? … Continue reading Is it possible to circumvent role-based row-level security with a well-crafted DAX query?