Overview of PowerPivot features

re: Overview of PowerPivot features

Vish — Thu, 09 Sep 2010 10:31:49 GMT

Hi,

Will power pivot work on Mac office 2010? I really really hope it does. Please let me know.

re: Overview of Gemini features

Ashvini Sharma [MSFT] — Tue, 25 Aug 2009 19:54:54 GMT

Hi Tiago,

Refreshing data from within the Excel addin is not possible in CTP2. However, as you describe, this is a very common need and it's very likely to be supported in a future CTP.

Thanks for the feedback

ash

re: Overview of Gemini features

Ashvini Sharma [MSFT] — Tue, 25 Aug 2009 19:52:47 GMT

Hi Kasper,

You're correct, the Gemini embedded data engine loads data into memory. However this is only while the models are in use. Gemini's SharePoint services manage the lifetime of these models and move these in and out of the SP content database transparently from the end users, the only realization users might have is the first time they connect to a model it takes slightly longer because we're extracting the workbook then extracting the AS database and loading it up in memory.

regards

ash

re: Overview of Gemini features

Tiago Rente — Tue, 25 Aug 2009 17:07:06 GMT

You meantion that the underlying Data can be refreshed in SharedPoint.

What about refreshing the data directly in Excel via Gemini?

Imagine that the Workbook I am creating has some complexity and takes a few days to create. By the time everything has been loaded, connected (relationships) the data has changed. Before, you save it to SharePoint (and share it with the Team, Department) you want to check that everything is OK. However, that is not possible in Excel/Gemini, right?

Thanks,

Tiago Rente.

re: Overview of Gemini features

kjonge — Tue, 25 Aug 2009 14:28:13 GMT

I love the feature that let you use the Gemini Applications as Data Sources!

But i was wondering, since Gemini is in memory, what it would do to the server performance when you have a lot of gemini applications running on SharePoint? Would it all be in memory or would ik be loaded into memory when called upon?

Thanks,

Kasper de Jonge