Summary


In this chapter, we have examined the new Business Intelligence capabilities available in SharePoint Server 2007 through Excel Services. We began with a discussion of how to configure Excel Services on servers where Office SharePoint Server 2007 has already been installed. We identified the basic steps required to enable Excel Services and to configure a Trusted File Location, which will allow workbooks to be processed on the server. Next we reviewed the roles of the major components of Excel Services-including Excel Calculation Services, Excel Web Access, Excel Web Services, and the Excel Calculation Service Proxy. We then explained how to publish workbooks through the Publish command in Excel 2007, including how to hide sheets and define parameters that affect the way users interact with the workbook. We then looked at the ways that users can work with workbook data through Excel Web Access and Web Access Web Parts. In the next section, we described ways to control security on workbooks accessed by Excel Services. We discussed performance considerations with Excel Web Services, including controlling the number of sessions and the timeout duration for each session. Finally, we looked at ways that workbooks can access external data sources from within Excel Services.




Microsoft Office Sharepoint Server 2007 Administrator's Companion
MicrosoftВ® Office SharePointВ® Server 2007 Administrators Companion
ISBN: 0735622825
EAN: 2147483647
Year: 2004
Pages: 299

Similar book on Amazon
Microsoft Office SharePoint Server 2007 Best Practices
Microsoft Office SharePoint Server 2007 Best Practices
Microsoft SharePoint 2010 Administrator's Companion
Microsoft SharePoint 2010 Administrator's Companion
Professional SharePoint 2010 Administration
Professional SharePoint 2010 Administration
Inside Microsoft  Office SharePoint  Server 2007
Inside Microsoft Office SharePoint Server 2007

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net