Sharing workbooks using PowerPivot Gallery

re: Sharing workbooks using PowerPivot Gallery

Jan Renken — Thu, 23 Sep 2010 12:02:04 GMT

The PowerPivot Silverlight looks like very nice eye-candy.

Does this webpart/page also work as a PerformancePoint - Dashboards gallery (with generated thumbnails)? Or does alternatively any Silverlight gallery for Dashboards exist?

Best regards,

Jan

re: Sharing workbooks using PowerPivot Gallery

Will Riley — Fri, 19 Mar 2010 15:39:34 GMT

Eric,

As far as I can tell from my sandbox set-up I'm running, PowerPivot models are hosted in SSAS on deployment to Sharepoint. There is no other alternative... PowerPivot for Sharepoint "IS" effectively a Sharepoint-integrated SSAS engine.

As discussed at length, locally the models run "in-memory", but given the multidimensional way the data is generally modelled, I guess it made more sense to host in an SSAS instance as opposed to a regular DB instance (a sort of OLAP versus ROLAP trade-off).

Regards,

Will

re: Sharing workbooks using PowerPivot Gallery

Eric Livesay — Wed, 10 Mar 2010 17:02:17 GMT

Do you have to have analysis services hooked up to all the powerpivots in order to browse them in sharepoint? or can i just have a powerpivot that runs off of a regular database...

It seems a big limitation if you have to put every data source in analysis services just to have a report available in sharepoint...

re: Sharing workbooks using PowerPivot Gallery

Olivier Travers — Thu, 03 Dec 2009 13:01:33 GMT

This looks pretty interesting. I'm trying to wrap my mind around what's going to be possible. Here's a use case that I'd like to know whether it's going to be supported:

- the user is a publisher with a public-facing site (not a restricted extranet)

- the products used would be Excel 2010 and Sharepoint Foundation hosted by a third-party (i.e. managed hosting)

- the intended use is to embed browser-based PowerPivots (presumably javascript/AJAX?) and PowerPivot Galleries (apparently Silverlight) on a public website. The core need is cross-browser support, IE-only won't jibe with a general audience.

Does that make sense and is it an intended (or at least possible) use for these new products? Can the data be stored in an Excel spreadsheet on the server (assuming there's relatively little data) or do you have to use a SQL server in the mix no matter what?

Right now we're using SP WSS 3.0 internally but the lack of cross-browser support for its Office-related features has ruled it out for public use.