Save view of data - OWC

[ilona]

Hi,
I'd like to know if in Excel Pivot Table component there is some
functionality that would allow users create pivot table reports against
Analysis Services 2000 cubes and save these reports somewhere on the network
share so that different users can access these pre-configured reports
(instead of starting them from scratch) and when they open them, the data
would be re-queries from the Analysis Services cubes.

What I'd like to achieve is to give multiple users capability of quickly
getting to the data that they need from a single source.

 

[Mark G]

You can save the OWC PivotTable definitions created by the users using the
XMLData property. This will take some serious application development, but
it is possible.