If you are accessing the BAM portal from a machine that doesn't have BizTalk installed, you may get the following error:

The query could not be processed:
  Cannot connect to the server 'host'. The server is either not started or too busy.

If you get this error, you may not have the Office Web Component (OWC11) activeX control and the corresponding database drivers on your machine.

The OWC11 active control uses MSOLAP provider to access the analysis services and you must have version 9.0

Here is where you can get the update from Microsoft:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en


Microsoft Core XML Services (MSXML) 6.0

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Use msolap.3 for AS2005 and msolap.2 for AS2000 using only provider=msolap use the default provider (generally the most recent driver)

SSPI=Kerberos is required when the web server and the OLAP server are on 2
diffrents servers (search for IIS + kerberos keywords on the MS website to
learn more)