SSAS – object reference not set to an instance of an object error

You attempt to Build your Analysis Services solution but get a “object reference not set to an instance of an object” error when you try the Build function.   This can be any number of things but as a guide you can try checking the following within your SSAS solution :

DSV – Check the DSV and make sure each object returns data without error.

Dimensions – Check each and every dimension in the solution by manually opening and checking for errors.  Alternatively install BIDS helper and activate the Dimension Health Check on each.

Measures – Check the aggregation property and ensure the Aggregation function is correct.  For example if you don’t have a Date Dimension in your solution but have selected Last Non Empty, this will trigger the object reference not set to an instance of an object error.

Note – Restarting Visual Studio is unlikely to resolve.

Happy error hunting.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

4 Responses

  1. Jan van Egmond

    try opening the design aggregations wizard or the usage based optimization wizard. In my case a detailed description of the errors was shown

  2. Tausif

    This also happens when you change dimension attribute which is used in Cube’s Dimension usage as Relationship attribute. Either set it to no-relationship of set it back to the attribute.

  3. I had this similar issue and in my case it was caused by a bad aggregation Design in one of the measure group, once the deleted that aggregation design, the solution started building fine without any error of “object reference not set to an instance”. if you are using multiple aggregation designs in your OLAP cube then try to remove them one by one to figure out which one is causing this issue. (Pls. take a backup of your CUBE schema or do it in a test environment.)

    Sometime aggregation design cracks when you choose to do a FULL aggregation for those attribute which have lot of members. It is very frustrating to see that error without any context why it is breaking.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s