Am facing a very common issue in Office 2003 web components using sharepoint....I have few dashboards to be run on my SP team site..
Unable to access the dashboard(Office Pivotchart in office 2003 web components) when I open it in Client machine..but am able to view them in the server(main server..same domain and pwd is given in client as well).
Pivotcharts Show an alert "Microsoft Office 2003 Web component Errors" ,Failed to get data. If available, errors returned from the provider
Tried checking the internet settings-->tools>access datasources across the domains option
Tried checking for roles and permissions in analysis db...am still yet to resolve:(
I checked in some article regarding giving access to cube role manage using "enforce on "..Am unable to repplicate the same in SQL SERVER 2008 Analysis DB.