FAQ #3: How do I find the location of the OLAP cube?

I've heard this one a couple of times and asked it myself a couple of times.  When I use Excel to do an analysis of the project data, I need to connect to the OLAP cube (Data->From Other Sources->From Analysis Services). I get a dialog that asks the address of the database server.  Here's a tip on how to find the address (this comes from Doug Mortensen on our team):

Note: If you don't see the video below, try a refresh of the page.  It should turn up then.

Thanks,

-Siddharth

Comments

• Anonymous
  July 25, 2011
  Any chance of reposting this video?