Index 761
key data columns, 485
Key Performance Indicators. See KPIs
keys
removing rows with duplicate sort, 236
selecting in Slowly Changing Dimension
Wizard, 231, 232
KPI Browser, 348, 349
KPIs (Key Performance Indicators)
adding to cube, 346–349
client software support for, 346
creating, 344–346
defined, 18, 342
digital dashboard model for, 342–343
management use of, 17, 18
status levels of, 343
L
Lag function, 398
LastChild function, 399, 400
LastSibling function, 399, 400
latency
business intelligence and, 18, 19
data marts and, 31
disadvantage in OLAP systems, 53
UDM’s low, 59
launching Report Builder, 666–668
layout
adjusting matrix report, 589–591, 592,
593–595
Integration Services package design, 143–144
pivot table, 719, 725–727
rectangles and borders in report, 601
SQL Server Management Studio default
window, 83–85
Layout tab (Report Properties dialog box), 606
layout-led discovery, 14–15
Lead function, 398, 399
Learn By Doing exercises, 109, 131
Legend tab (Chart Properties dialog box), 621, 623
Level function, 451
Lift Chart
about, 520, 525
illustrated, 528, 529, 530, 531
prediction value unspecified, 526–527
specified prediction value, 527–529
Linked Object Wizard, 339–340
linked reports in Report Server, 648, 649
linking objects to cubes, 338–340
list data regions, 597–598
list reports, 598–611
adjusting page size of, 605–607
editing field expressions in, 601–602
embedding images in, 602–604
list data regions and, 597–598
page numbers for, 607–608
rectangles and borders in, 601
setting text properties for, 606–607
literals in Integrated Services, 246–247
Load InventoryFact data flow task, 285, 286
LoadDimBatch data flow task, 278–281
local administrator privileges, 640–641
local reports, 710–716
defining data source for, 711–715
setting up new report link, 711
logging for Integrated Services packages, 254–256
Logical function, 451
logical operators in MDX, 449
long-term goals, 16, 17
Lookup transformation, 220–222
low-latency MOLAP data storage, 362
M
Maintenance Cleanup task, 166–167
maintenance of UDM architecture, 60
Maintenance Plan tasks, 162–171
about, 162–163
Back Up Database, 163, 164
Check Database Integrity, 163–165
Execute SQL Server Agent Job, 165, 166
Execute T-SQL Statement, 165–166, 167
History Cleanup, 166
Maintenance Cleanup, 166–167
Notify Operator, 167–168
pointer entries in Control Flow Toolbox, 163
Rebuild Index, 168–169
Reorganize Index, 169, 170
Shrink Database, 169–170
Update Statistics, 170–171
management
decisions of upper, 17–18
levels of decision making by, 16–17
mid-level decisions, 18–19
managing
dimensions, 307
report history snapshots, 654
manufacturing automation system, 21
Manufacturing data mart
adding hierarchies to schema, 113
762 Delivering Business Intelligence with Microsoft SQL Server 2005
adding second fact table to, 275–276
attributes for, 111
completed schema for, 114
CSV text files in, 274
dimensions for, 110, 111
measures requested for, 109, 110
populating fact tables in, 277–286
schema with measures and dimension
tables, 112
Manufacturing Data Mart Report Model, 664
Manufacturing Data Mart.smdl file, 660, 661
ManufacturingFact table
creating, 122
creating relationship with DimProduct
table, 126
designing, 112
many-to-many dimensions, 314
mapping
data mart population column, 280,
283–284, 285
deleting mining model column, 522, 524, 525
test data to mining model, 522, 524–525
topographic, 458–462
match indexes, 218
mathematical functions, 249
Matrix Properties dialog box, 591, 592
matrix reports
about, 668
about matrix data regions, 587–588
adjusting layout of, 589–591, 592, 593–595
enabling drill down data, 591
Max Min Manufacturing DM cube, 377
Max Min Sales star schema, 138
Maximum Miniatures, Inc.
about, 12, 20
business needs of, 20–21, 107–109
completed data mart schema for, 114
data processing systems of, 21–23
designing data mart for, 106–114
MaxMin.com online store, 22
MaxMin data mart, 155–162
MaxMinManufacturingDM data source, 723–724
MaxMinManufacturingDM tables, 120–121,
127–128
MaxMinReports Property Pages dialog box, 630
MaxMinSales cube, 135
MDI environment option (Options dialog box),
79–82
MDX (Multidimensional Expression) language. See
also MDX queries; MDX scripting
about, 90, 297
case sensitivity of expressions, 378
expression errors in scripting, 383
functions in, 450–454
operators in, 448–450
tuples enclosed in parentheses in
expressions, 378
MDX queries
about MDX SELECT statement, 422–423
building MDX report queries, 590, 591
CROSSJOIN function in, 439–440
FILTER function in, 432–434, 435
incorporating results with ADOMD.NET,
677–683
pivot tables and charts use of, 719
specifying calculations producing nonempty
results, 299
used by pivot tables and charts, 719
using WITH statements in, 435–439
working with basic MDX SELECT statements,
424–426
MDX Query Builder, 590, 591, 599
MDX scripting. See also scripts
adding name attributes, 388–389
aggregate cell sets specified with, 385–387
calculated measures in, 297
calculating member to return value from
previous year, 416
distant relative position between hierarchy
levels, 401–402
enclosing identifiers in square brackets, 378
Excel range operators in, 387–388, 389
expression errors in, 383
finding comparison cell position, 395–396
finding relative position within hierarchy level,
397–399
immediate relative position between hierarchy
levels, 399–400
providing user-friendly hierarchy level names,
390–394
returning year-to-date value, 416–418
setting dimensions as default members,
383–385, 390
shortcuts for expressions in, 380–382
specifying NameColumn property for
hierarchy, 395
syntax with Measures pseudodimension, 407
viewing calculated measure definitions,
299, 300
measurable goals, 8–9
measure groups. See also measures
adding to cube, 303, 304

Get Delivering Business Intelligence with Microsoft SQL Server 2005 now with O’Reilly online learning.

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