SSAS - "Deserialization failed: Error when trying to open cube designer in Visual Studio (SSAS)"

Peter Schmitz

Administrator
Staff member
This morning, I changed a few measure names in SSAS. Shortly after that, SSAS completely forze on me. I ended up having to end the process, and restart.

When that was done, I was greeted with the error:

Deserialization failed: Error when trying to open cube designer in Visual Studio (SSAS)

As it turns out, the new name I provided for my measures was already used in a different measuregroup, and the graphical design window couldn't load because of that.

The solution was to right-click the cube, and select "View Code" (Or press F7). In the code, I then located the invalid names, and changed them back to their originals.
 
Top