Managing Core SQL Server 2008 R2 Technologies - Microsoft SQL Server 2008 R2 Administration - page 179

20. Select ExcelServiceApp1 (Excel Services Application Web Service Application) and
click Manage to choose Trusted file locations.
21. Click on http:// to change the Excel Services settings. Navigate to the Workbook
Properties section. For this recipe, choose the value of the Maximum Workbook Size
as 3192 MB.
22. The new settings will take effect once the IIS services are restarted.
We have now successfully completed the PowerPivot for SharePoint installation, now the
instance is ready to publish and share the PowerPivot workbook.
To ensure the PowerPivot for SharePoint installation is successful and to share a workbook,
we can test the process by publishing a PowerPivot workbook instance, as follows:
1. Switch on the machine with Excel and PowerPivot for Excel.
2. Open a workbook.
3. Click on File | Save and Send | Save to SharePoint | Save As.
4. Enter http://<yourPowerPivotserver>/PowerPivot Gallery in the folder
path of the Save As dialog, and click Save.
How it works...
Microsoft Excel is a popular Business Intelligence tool on the client side, and to present
data from multiple sources PowerPivot for Excel is required. The installation process of
the PowerPivot add-in on the client side is a straightforward process, though there is no
requirement of SQL Server 2008 R2 components on the client side. Behind the scenes, the
Analysis Services VertiPaq engine from PowerPivot for Excel runs all the 'in-process' for Excel.
The connectivity to the Analysis Services data source is managed by MDX , XMLA Source , AMO ,
and ADOMD.NET libraries, which in turn use the Analysis Services OLE DB provider to connect
to the PowerPivot data within the workbook.
On the workstation, the Analysis Services VertiPaq engine issues queries and receives data
from a variety of data sources, including relational or multidimensional databases, documents,
public data stores, or Web services. During data import and client-side data refresh, an ATOM
data feed provider is used for importing and refreshing data in the ATOM format.
In case of connectivity to non-Microsoft data sources such as Oracle/Teradata/DB2/
SYBASE/SQLAzure/OLEDB/ODBC sources and most commonly used file sources such as
Excel or flat files, we must acquire and install these drivers manually.