390
parameterizing reports – regular relationships
relationships – reporting
18
exposing bad, 115
foreign keys, physical constraints, 18
many-to-many, 142
one-to-many, 142
referenced, 142
regular, 142
types,
256–257
editing reports, 274
opening, 273–274
overview, 273
Report Part Gallery, 276
report parts, 276–277
shared datasets, 277–278
wizards,
192
adding items,
337
viewing reports,
248–249
deploying to, 247
port settings, 248
security,
203–205
color, 201
datasets, naming, 202
launching, 199
matrix reports, 200
Preview Report checkbox, 201
query design screen, 200
report name, 201
tabular reports,
193
Analysis Services cubes, 223
automated from different systems, 4
BI add-on from vendor, 4
parameterizing reports
matrix reports, 221–222
MDX, 225
overview, 215
parameters
available values, 217–218
creating, 215–216
default values, 216–217
multi-value, 218–219
stored procedures and, 215–216
partitioning, 18
aggregation design, 183–185
measure groups, 183–185
security and, 177–178
Partitions tab (Cube Editor), 133
Percentage in Territory, 158–159
percentage of parent calculation, 159–160
performance tuning, cube, 123
PerformancePoint
Analysis Services, Unattended Service
Account, 345–346
content creation, 344
Content Library, 344
dashboard, deploying to SharePoint, 347–352
Dashboard Designer, 344
data source connection, 344
Decomposition Tree, 343344
KPIs, 343
SharePoint and, 343
Perspectives tab (Cube Editor), 133
physical foreign key constraints, 18
Pivot Charts, PowerPivot, 306307
PivotTable reports, 286
PowerPivot
capabilities, 295–296
DAX expression, 299, 304
downloading, 295
environment, 296–298
importing data, 298–300
installation, 296
reports
adding SharePoint, 361
building, 304–305, 308311
components, 303
conditional formatting, 306–307
deploying to PowerPivot Gallery, 364–369
importing data, 304
Pivot Charts, 306–307
sparklines, 306–307
workbooks, loading data to, 301
PowerPivot Gallery, 361
creating, 364–369
PowerPivot Management
Dashboard, 372
precedence constraints, 37
previewing reports, 193–195
primary keys, integrating, 11
proactive caching, 181
projects, creating, 28
properties
AggregateFunction, 131
OverwriteDatasets, 247
OverwriteDataSources, 248
Report Server Mode, 337
reports, parameters and, 219–220
TargetDatasetFolder, 248
TargetDataSourceFolder, 248
TargetReportFolder, 248
TargetReportPartFolder, 248
TargetServerURL, 248
provider, selecting, 105–106
Q
queries
attribute relationships and, 123
cube, 153–154
dashboards, 240
data mining model, 170–171
data warehouses, 98
datasets, 217
MDX Query Designer, 223
shared datasets, 191
spatial data in reports, 236–238
stored procedures, 191
Query Builder, 200
R
redundancy, consolidation, 9
referenced relationships, 142
regular relationships, 142
889633bindex.indd 390 8/17/10 6:34:42 AM

Get Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.