Specifications

208
data feed libraries, 205
Data Movement Service (DMS), 112
data racks, 111
data sources
joining, 166-168
for PowerPivot for Excel, 191-193
data stewards, 127
data types
supported in Parallel Data Warehouse, 120
supported in PowerPivot, 195
data warehouse appliances, 109-110. See also Parallel
Data Warehouse
database consolidation, 86
database creation, 118
database objects, managing, 122
Datacenter edition, 12
datasets. See also PowerPivot for Excel; PowerPivot for
SharePoint
combining data from multiple, 166-168
importing large, 192
shared, 179
data-tier applications (DACs). See DACs (data-tier
applications)
Data-Tier Applications viewpoint (Utility Explorer),
100-105
DAX (Data Analysis Expressions), 199-201
DDL extensions, 117
default policies, restoring, 36
denitions, DAC
registering, 49
storing, 43
Delete Data-Tier Application Wizard, 56-58
Deploy Data-Tier Application Wizard, 52-55
deploying DACs, 45
conguration options, 53
with Deploy Data-Tier Application Wizard, 52-55
overview of, 4
report for, 54
in Visual Studio 2010, 45-46
deploying StreamInsight, 149-150
deploying UCPs
with Create Utility Control Point Wizard, 26-28
prerequisites for, 25, 26
report, saving, 28
with Windows PowerShell, 28
detaching DAC database, 56
Developer edition, 13
diagnostic views (StreamInsight), 163
disconnecting from UCPs, 34
disk space consumption, 25
control racks, 112
count windows, 159
CPU
overutilized, 92
upgrading online, 63
CREATE DATABASE statement, 118
Create Package wizard, 142
CREATE REMOTETABLE statement, 120
CREATE TABLE statement, 118-120
Create Utility Control Point Wizard, 26-28
CSV (Cluster Shared Volumes). See also failover clustering
adding storage to, 76
enabling, 76
overview of, 64
storage location, 76
cube functions, 197
D
DAC le packages, 45
DACs (data-tier applications)
benets of, 44
conguration options, 53
dened, 41
denition registration, 49
denition storage, 43
deleting, 56-58
deploying, 4, 45, 52-55
detaching database, 56
extracting, 49-51
generating, 43
importing, 47-48
life cycle of, 42-43
monitoring, 93-94, 100-105
project templates, 45-46
properties, setting, 49-50
red or yellow icons, 45
registering, 55-56
SQL Server objects supported in, 44-45
upgrading, 59-61
uses for, 43
Visual Studio deployment of, 45-46
dashboard, PowerPivot, 206
Data Analysis Expressions (DAX), 199-201
data bars, 175
data colocation, 114-115
data feed, Atom
exporting reports to, 182
importing data into PowerPivot workbook, 191
control racks