Database Reference
In-Depth Information
PowerPivot for SharePoint installs on top of SharePoint 2010, and adds services and
functionality to SharePoint. As we have seen, PowerPivot for Excel is an effective tool to
create and edit PowerPivot applications, and for data collaboration, sharing, and reporting
PowerPivot for SharePoint. Behind the scene, SQL Server 2008 R2 features SharePoint
2010 integrated mode for Analysis Service which includes the VertiPaq engine to provide
in-memory data storage. It will also help in processing very large amounts of data, where
high performance is accomplished through columnar storage and data compression.
The storage of PowerPivot workbooks is quite large and SharePoint 2010 has a default
maximum size limit of 50MB for file size. As per the enterprise storage policies, you need to
change the file storage setting in SharePoint to publish and upload PowerPivot workbooks.
Internally, PowerPivot for SharePoint components, PowerPivot System Service, and Analysis
Services in VertiPaq will provide the hosting capability for PowerPivot applications internally.
For client connectivity to publish, it includes a web service component that allows applications
to connect to the PowerPivot workbook data from outside the SharePoint farm.
There's moreā€¦
Creating an Excel workbook that contains PowerPivot data requires both Excel 2010 and the
PowerPivot for Excel add-in. After you create the workbook, you can publish it to a SharePoint
Server 2010 farm that has Excel Services, and a deployment of SQL Server PowerPivot for
SharePoint. PowerPivot workbooks can be opened in Excel 2007.
However, Excel 2007 cannot be used to create or modify PowerPivot data, or to interact with
PivotTables, or PivotCharts that use PowerPivot data. You must use Excel 2010 to get full
access to all PowerPivot features.
Implementing Microsoft StreamInsight
Technologies Platform
Every Enterprise has always been on a continuous press to reduce the lag between
data acquisition and data processing. When talking about moving data from a traditional
desktop-based application to an Enterprise data warehouse application, the technology
must support complex event processing and provide proactive results from monitoring.
 
Search WWH ::




Custom Search