Categories
Uncategorized

SSMS Templates for SSAS Developers

Templates and Snippets are two nice little features in SSMS that allow you to quickly generate standard code statements.  They come with a fairly substantial list of generic statements to get you started, but if you’re OCD and/or lazy (like most good DBAs and developers) you can customize the existing ones or add a few of your own. Snippets […]

Categories
Uncategorized

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 […]

Categories
Uncategorized

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 […]

Categories
Uncategorized

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 […]

Categories
Uncategorized

SQL Profiler EventClass & EventSubClass Column Descriptions for SSAS 2012

Lately, I’ve been spending quite a bit of time troubleshooting some performance issues related to PowerView reports running against a SQL Server Analysis Services 2012 Tabular data source.  One of the first steps in the troubleshooting process involved turning up a SQL Profiler trace on the SSAS Tabular instance and having the users reproduce the […]

Categories
Uncategorized

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? At the time, we all agreed that the notion seemed ridiculous…if that were possible, what’s the point of even having […]

Categories
Uncategorized

Real Time OLAP = TRUE

While testing the performance of ROLAP (with a ColumnStore index on the fact table) for another post (I’m still working on), I noticed something that made me stop and think “wtf?” What I noticed was that, while sending an MDX query to the ROLAP cube multiple times, the initial query would show up in both […]