When recieving this error:
Microsoft Server Applications
The authenticated user cannot access the requested cube. Please verify that the authenticated user has proper privileges to the requested cube on the SQL Server Analysis Services instance on which it is hosted, and that the client machine has the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider installed. Additionally check the browser settings for the internet zone this site shows up in and verify that the setting called "Access data sources across domains" under Miscellaneous is set to "Enable" or "Prompt".
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is required for the Office Web Components to communicate with Microsoft SQL Server 2005 AnalysisServices. This is a standard component bundled with recent Microsoft products such as Office 2007 and SQL Server 2005 Management Studio, and is also available from the Microsoft Web site. To download Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, navigate to the section labeled "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider" at the following URL: http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en.
Click the link and scroll down to SQLServer2005_ADOMD_x64.msi and download
http://download.microsoft.com/download/f/7/4/f74cbdb1-87e2-4794-9186-e3ad6bd54b41/SQLServer2005_ADOMD_x64.msi
Next download the SQLServer2005_ASOLEDB9_x64.msi
http://download.microsoft.com/download/f/7/4/f74cbdb1-87e2-4794-9186-e3ad6bd54b41/SQLServer2005_ASOLEDB9_x64.msi
This should fix the issue.