Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

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

Discussion in 'Business Intelligence' started by Peter Schmitz, Jun 12, 2017.

  1. Peter Schmitz

    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:

    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.

Share This Page