Tabular translator for SQL Server 2016 on github
With the just released CTP 3.3 for SQL Server 2016 Analysis Service we can now provide translations to your Tabular models. As you might have... Read more
Category: Analysis Services
System Center Management Pack for SQL Server 2012 Analysis Services
Great news, Microsoft just released the System Center Management Pack for SQL Server 2012 Analysis Services. What is in it: System Center Operations Manager (SCOM) is... Read more
Detailed operational reporting in Excel 2013 and Power View
A scenario that is quiet common is the following, as part of my analysis I want a flat list of all Customers and their OrderNumbers... Read more
Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services
I just got back from a vacation so I have some catching up to do 🙂 One of the cool things that happened is the... Read more
When Importing from Tabular Model use DAX
I recently was building a model in Excel that was using data from a Tabular Model. I started going down the import path by selecting... Read more
Using Traditional SSRS parameterized reports against a Analysis Services Tabular model using DAX
I get this question every now and then: Is it possible to create a traditional SSRS report with parameters against a tabular model using DAX.... Read more
Hardware Sizing a Analysis Services Tabular Database
I just quickly wanted to point out that that there is now a whitepaper available on “Hardware Sizing a Tabular Solution” You can download it... Read more
What is new for the Tabular model in SQL Server 2012 SP1 and compatibility level.
On the surface the SQL Server 2012 SP1 looks very much like SQL Server 2012 RTM but there are some hidden gems in there that... Read more