Excel pivot tables from Analysis Services - Question on deployment to

[adandrea]

Hi,
I've created a couple of cubes in AS and some Excel spreadsheets, some with standard pivot tables and others with reports created with the Excel Add-In for Analysis Services.

The part I'm having problems with is that when I distribute the excel files, the receipients don't have the MS Query connections defined in their machines and hence they can't refresh or filter the reports.

I tried having people copy the .oqy files (for standard pivot tables) and also the .odc files (for the Excel Add-in) to their hard drives but users still can't refresh data. Could it be a credentials problem? Is there a better way to distribute the excel files without distributing the .odc and .oqy?

Thanks in advance,

Ale

 

[indupriya9]

Hi Ale

I am also facing the same problem. Did you get a solution for this? Please reply.

Cheers
ip

 

[adandrea]

ip, apparently it had to do with authentication and not with having to distribute the query. Actually the query definition gets distributed automatically with the spreadsheet, but you probably have problems with user authentication. I solved that by allowing http authentication instead of windows-based. I now have a scheme where anyone can access the cube, which is not ideal in terms of securiy, but I still haven't had time to fine tune that part.

Hope it helps,
Ale