Among the many new features coming w/ SSAS 2017, object-level security for tabular models is at (or close to) the top of the list for a few clients I work with. In fact, for 1 client, it is/was important enough that we decided to join the early adopter program (EAP) and officially run the preview […]
Tag: Tabular
It wasn’t until just a few weeks ago, while performing a design assessment on a very large tabular model, that I was finally able to appreciate one of the most underrated improvements made in SSAS Tabular 2016. This particular client was on SSAS 2014 and had a very mature tabular model consisting of… 64 tables […]
Much of my client work these days is focused on performance… making slow Analysis Services servers run faster. The good part about these types of engagements is that there’s usually (not always) a good amount of low-hanging fruit and I get to play the hero that swoops in to save the day. The bad part about these types of […]
Earlier this week, while discussing high-concurrency architecture options for SSAS multidimensional, a colleague asked about options for SSAS tabular and mentioned there was very little information available online specific to tabular…and so, a blog post is born. The short answer is that Scale-Out Query Architecture for Tabular is essentially identical to that for multidimensional. And […]
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 […]
byoBI.com 