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

  • Article

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