Microsoft SQL Server 2008 R2 810-08234 Benutzerhandbuch
Produktcode
810-08234
PowerPivot for SharePoint
CHAPTER 10
201
FUNCTION TYPE
EXAMPLE
DESCRIPTION
Statistical
=AVERAGEX(ResellerSales,
[SalesAmount]-
[TotalProductCost])
[SalesAmount]-
[TotalProductCost])
Evaluates the expression in the
second argument for each row of
the table in the first argument, and
then calculates the arithmetic mean
second argument for each row of
the table in the first argument, and
then calculates the arithmetic mean
Text
=CONCATENATE([FirstName],
[LastName])
[LastName])
Returns a string that joins two text
items
items
Time Intelligence
=DATEADD([OrderDate],10,day)
Returns a table of dates obtained
by adding the number of days
specified in the second argument
(or other period as specified by
the third argument) to the column
specified in the first argument
by adding the number of days
specified in the second argument
(or other period as specified by
the third argument) to the column
specified in the first argument
PowerPivot for SharePoint
PowerPivot for SharePoint provides server-side support for PowerPivot workbooks by
extending the capabilities of SharePoint and Excel Services in SharePoint . SharePoint provides
centralized management of the PowerPivot workbooks, and Excel Services manages data
queries and the rendering of the query results in the browser . Installation of PowerPivot for
SharePoint adds services to the SharePoint farm and includes a document library template,
content types, dashboards, and Web parts that provide access to PowerPivot reports and
support monitoring their usage .
extending the capabilities of SharePoint and Excel Services in SharePoint . SharePoint provides
centralized management of the PowerPivot workbooks, and Excel Services manages data
queries and the rendering of the query results in the browser . Installation of PowerPivot for
SharePoint adds services to the SharePoint farm and includes a document library template,
content types, dashboards, and Web parts that provide access to PowerPivot reports and
support monitoring their usage .
Architecture
PowerPivot for SharePoint requires SharePoint Enterprise Edition and Excel Services . You
must install Analysis Services with SharePoint Integration on a SharePoint Web front end . In
SharePoint Central Administration, you configure the PowerPivot System Service and activate
the PowerPivot feature on the target site collection . PowerPivot for SharePoint uses a scalable
architecture (shown in Figure 10-12) that allows you to add or remove instances as needed
when you require more or less processing capacity . When you add an instance, the Share-
Point autodiscovery feature ensures that the new instance can be found, and the PowerPivot
System Service has a load balancing feature that will use the new instance when possible .
must install Analysis Services with SharePoint Integration on a SharePoint Web front end . In
SharePoint Central Administration, you configure the PowerPivot System Service and activate
the PowerPivot feature on the target site collection . PowerPivot for SharePoint uses a scalable
architecture (shown in Figure 10-12) that allows you to add or remove instances as needed
when you require more or less processing capacity . When you add an instance, the Share-
Point autodiscovery feature ensures that the new instance can be found, and the PowerPivot
System Service has a load balancing feature that will use the new instance when possible .