Analysis Services : Unable to Connect to Analysis Services

Problem :
Status from the Excel sheet: “Waiting for query to be executed”

Solution:
Uninstalling the Firewall application (Integrity Agent)

Analysis Services : No mapping between account names and security IDs was done.

Problem :
The following system error occurred: No mapping between account names and security IDs was done.

Cause :
Domain User present in Roles are no longer in the domain server.

Resolution :
Remove the domain user from the roles.

Analysis Services : Class not registered (Exception from HRESULT : 0x80040154 (REGDB_E_CLASSNOTREG))

Problem: Most likely the OWC component installation became corrupted.

Resolution: Try to repair your "Microsoft Office 2003 Web Components" installation.

Analysis Services : ‘Unknown’ Attribute in Browser

Problem: An attribute with label ‘Unknown’ is showing in the browser.

Resolution: Set UnknownMember to Hidden or None.

Analysis Services : "Unexpected Error occured" When trying to view calculations tab

"Unexpected Error occured" When trying to view calculations tab

Problem: Cannot browse the calculation tab.

Resolution:
this might be caused by version mismatch between some binaries. i'd suggest checking the versions of msmdlocal.dll and msmgdsrv.dll and making sure that the ones installed into %ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ are the same as those in %ProgramFiles%\Common Files\System\Ole DB\ (if they are not then try updating the ones in the PrivateAssemblies with the ones from ole db; you might want to save the original ones as to be able to get back to original state just in case...)