RDA Corporation

Blog

Analysis Services Error in Calculation Tab

By Steve Mann on January 15th, 2007 // 15 Comments

by Ray Barley

I recently built a cube using SQL Server 2005 Analysis Services and ran in to a problem. The Calculation tab in the project displays this text: Unexpected error occurred: ‘Error in the application.’ so I can’t define any calculations.

I found the solution on the
SQL Server Analysis Services forum on MSDN. There are 2 DLLs msmdlocal.dll and msmgdsrv.dll in these folders:

  • C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies
  • C:Program FilesCommon FilesSystemOle DB

The ones in the PrivateAssemblies folder are older versions so you copy the ones from the OLE DB folder to the PrivateAssemblies folder and the problem goes away.

In my case I know that I installed a SQL Server 2000 instance recently along with Office 2007 and this is the first time that I used Analysis Services since then so I think one of those might be the culprit.

About the Author:

  • http://www.nedorogo.kiev.ua/villa/en/index.html mv

    Thank you! :)

  • Ghyzi

    Many Thanks!
    I had the same problem since the installation of Office 2007…

  • Dave

    Thanks for the great information. Worked great

  • Anonymous

    Thanks a lot, works great for me.

  • Mel

    Same problem for me when i installed Office 2007. Thanks for the fix.

  • Anonymous

    Great! Worked like a charm! Thank you.

  • Linto

    Thank You…It give me what I was looking to solve the issue.

  • Anonymous

    appreciated your efforts…worked for me.

    AslamBughari@gmail.com

  • Andrew

    So many BI MVP’s and MS employees couldn’t answer this one in all the forums I’ve scoured. I’ve had this problem for over 6 months now and you’ve solved it! Champion! :)

  • Anonymous

    I had the same problem with sql 2005 office 2007, now its working.

    thank you very much..

  • Anonymous

    Awesome, that did the trick. Thanks!!

  • Anonymous

    THANKS !!!!!!!!!!!!!

  • Mad Mel

    Same problem here, solution worked perfectly. Thanks!

  • Anonymous

    Ditto to all the above…
    Thank You
    Thank You
    Thank You

  • http://www.blogger.com/profile/13644803403764223238 romualdo

    Thank you pal