-
Excel pivot tables from Analysis Services - Question on deployment to end users
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
-
Possible to install AS cllient on user pc?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|