parameterizing reports – regular relationships
391
relationships – reporting
relationships
enforcing, 18
exposing bad, 115
foreign keys, physical constraints, 18
many-to-many, 142
one-to-many, 142
referenced, 142
regular, 142
types, 142
renaming files, 6367
Report Builder, building report, 279–282
Report Builder 3.0, 256–257
editing reports, 274
opening, 273–274
overview, 273
Report Part Gallery, 276
report parts, 276–277
shared datasets, 277–278
wizards, 274–275
Report Data window, 192
adding items, 193
Report Manager
Reporting Services in SharePoint-integrated
mode, 337
viewing reports, 247
Report Parameter Properties window, 217
Report Server
configuration settings, 248–249
deploying to, 247
port settings, 248
security, 253255
Report Server Database Conguration Wizard, 337
Report Server Mode property, 337
Report Wizard, 199, 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, 200
reporting
adding items, 193
Analysis Services cubes, 223
automated from different systems, 4
BI add-on from vendor, 4
BIDS, 195–198
building reports, 190–195
color scheme, 201
cubes, data source, 223
data bars, 266–271
denormalization and, 9
departmental, 4
deploying, to Report Server, 247
lters, MDX, 225
formatting reports, 193–195
indicators, 266–271
individual data access, 4
influencers, 323327
maps, 229
adjusting, 235
bubble type, 232–235
converting address data to spatial data, 230
spatial data from query, 236–238
matrix reports, 200, 207–209, 211–214
parameters, 221–222
MDX Query Designer, 227–228
parameterizing reports, 215
parameters
available values, 217–218
creating, 215–216
default values, 216–217
MDX, 225
multi-value, 218–219
PivotTable reports, 286
PowerPivot
building reports, 304–305
importing data, 304
report components, 303
previewing reports, 193–195, 201
properties, parameters and, 219–220
report body, 193
report parts, 257–258
sparklines, 266–271
SQL, 223
SSRS and, 189
stored credentials, 250–251
subscriptions to reports, 251–252
tabular reports, 200
benefits, 207
fields, 200
viewing reports, 258–259
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 391 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.