connecting analysis services to excel (client side)

Hi,

How is the configuration of connection for a client Excel pivot table connected to Analysis Services? Is there anyway in which when we copy the .xls with pivot table to client PC, it will automatically connect to Analysis Services?

thanks in advance.

cherrie

Cherrie,

Do you have analysis services database installed on each pc and want to connect allways locally? If so, then in connection string instead of specifying machine name, use localhost.

If this is not what you ask, could you please clarify your question. What do you mean automatically connect to Analysis Services?

Vidas Matelis

|||

Hi,

Let's say I have a server in which Analysis Services is located together with my SQL Server database. Since currently, SSAS resides in my local drive from which the local excel is also connected through setting it up in Data > Import External Data > New Database Query > OLAP Cubes and it's doing well. But I'm thinking if let's say I want users to access the SSAS cube from the server to their local Excel? How would I configure the connection?

Thanks!

cherrie

|||

Cherrie,

It looks like you are using Excel 2003. Steps for your users will be exactly the same. You go :

Data > Import External Data > New Database Query > OLAP Cubes > <New Data Source> > etc

Then you specify data source name, provider, click connect and specify "Analysis Server" name. This name could be name of your machine or SSAS Server.

Leave UserID & Password empty, then select database and you are done.

Vidas Matelis

|||

Vidas,

Can the connection be stored in the UDL instead or store the connection somewhere in the local drive of the user apart from the .xls file?

Cherrie