26 Jun 2015
By Allen
0 Comments

SSAS Tabular Error “The object reference not set to an instance of an object”

SSAS, ,
This just goes under the blog tag "Useless Error Messages". My instance of this error happened when I added a new calculated column. Finally I realized I had named the new column the same as another column in a different table. Changed one of the names and no error. Lesson learned: SSAS Tabular is picky about not having two columns named the same. So boys and girls, only you can prevent stupid coding mistakes...
Read More
30 Apr 2013
By Allen
0 Comments
How to fix “Usage Based Optimizer” connection errors in SSAS 2012

How to fix “Usage Based Optimizer” connection errors in SSAS 2012

SSAS, , ,
The Usage-Based Optimizer can be a very powerful tool for calculating aggregations, when it works. When it doesn't work perfectly, then it can be frustrating to figure out. The devil is in the details. If you move data between environment, then you have even more details to find and fix. Just for a quick overview, in Visual Studio for 2012 (BIDS for previous versions) your project properties deployment will point at an SSAS Server Instance which in turn has to have query logging configured to point to a SQL Server database.  That database table, then logs info about the queries…
Read More