Tuesday, June 26, 2007

Project Server 2007: "You must have the valid Analysis Services database name and cube name."

I know how long you took to setup analysis services (if you did a server farm environment deployment with App and Web Server on a separate box and SQL on another) and now you run into this error when you try to create a new view and connect to the cube.

You get the fallowing error: "You must have the valid Analysis Services database name and cube name." It's not the best feeling in the world.

I took a look at this link, they said that it's all about enabling "Access data across domains" in Internet Explorer (Tools > Internet Options > Security > Trusted Sites > Custom Level). I just say add the PWA URL to your Trusted Sites.

I tried that and it didn't work. I'm quite sure the full working solution would be:

  • Ensure Office Web Components are installed.
  • Install Microsoft Core XML Services (MSXML) 6.0
  • Install Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
  • Ensure that PWA URL is added to your Trusted Sites

The MSXML and OLE DB can be downloaded from here.

4 comments:

Anonymous said...

The key here is enabling "Access data across domains" from in the "Trusted Sites" section of your security settings (if you have added your pwa site as a trusted site)

Anonymous said...

Thanks a lot? your advisec are very helpful!!

Anonymous said...

Apart from this, Please make sure you install SQLServer2005_ASOLEDB9.msi on the server hosting PWA (if SQL Server is different from PWA Server). For me this was missing.

Kevin said...

Nice One!

I came across this issue, it ended up being the SQL OLE db9 download add-on we needed, for each workstation.

Also, we use the intranet zone instead of trusted zones. This zone is there for a reason and should be used, otherwise you just end up recreating the settings in the trusted zones which are already available in the intranet zone.