Thursday, August 20, 2009

SSAS-Calculation member error

When accessing calculation tab in Business Intelligence Development Studio (BIDS) I am getting error "Unexpected error occurred:Error in application".

Fix / Workaround/Solution


Most likely this error is caused by mismatched SSAS dlls: msmdlocal.dll and msmgdsrv.dll. To fix this move this 2 dlls from folder:

c:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\
To folder:
c:\Program Files\Common Files\System\Ole DB\


Note: Before replacing any dll make sure you backup them to safe location.

This solution worked for me.

No comments:

Post a Comment