Microsoft SQL Server 2008 R2 Specifications download pdf (Page 221)

PowerPivot for SharePoint CHAPTER 10 201

FUNCTION TYPE EXAMPLE DESCRIPTION

Statistical

=AVERAGEX(ResellerSales,

[SalesAmount]-

[TotalProductCost])

Evaluates the expression in the

second argument for each row of

the table in the rst argument, and

then calculates the arithmetic mean

Text

=CONCATENATE([FirstName],

[LastName])

Returns a string that joins two text

items

Time Intelligence

=DATEADD([OrderDate],10,day)

Returns a table of dates obtained

by adding the number of days

specied in the second argument

(or other period as specied by

the third argument) to the column

specied in the rst 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.

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 congure 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.

1 2 ... 216 217 218 219 220 221 222 223 224 225 226 ... 235 236

No comments

Microsoft SQL Server 2008 R2 Specifications Page 221