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
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
ManufacturingFaet 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
MaxMinManufacluringDM 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
counting number of members in, 306
creating multiple partitions from single table, 356–359
defined, 294
dimensions and, 295, 296
multiple partitions for, 353–355
partitions and, 352
relating to dimensions, 308–311
setting granularity for, 310–311
measures. See also measure groups
adding formatting to, 305
adding to pivot tables, 730, 732, 733
additive, 300, 303
aggregate functions used in OLAP cube for, 302–303
calculated, 297–300
defined, 32, 294
nonadditive, 300, 302, 303
processing, 323
selecting in Cube Wizard, 132
semiadditive, 301–302, 303
setting aggregate function for, 303, 304–305
setting Aggregate property for aggregate functions, 300–301
specifying for data marts, 102–103, 109–110
storing in fact tables, 32, 35–37
viewing highest or lowest values for, 441–444
Measures dimension, 437–439
medium-latency MOLAP data storage, 362
members. See calculated members; default members; dimension members
Membership page (Role Design tab), 405
Merge Join transformation, 222, 224
Merge transformation, 222, 223
merging data flows, 222, 223, 224, 238, 240
Message Queue task, 186, 187
metadata, translating, 371–373
MHTML device information parameters, 698
Microsoft Association algorithm
about, 476–477
Dependency Network viewer for, 515–516
Itemsets viewer for, 514, 516
Rules viewer for, 514–515, 516
viewing data for, 513–517
Microsoft Clustering algorithm
about, 474–476
cluster characteristics, 511, 513
cluster diagrams, 509–510, 511
cluster discrimination, 511
cluster profiles, 510–511, 512
examining, 509–512
Microsoft Decision Trees algorithm
about, 472–473
decision tree view, 500, 502
sample exercise using, 493, 496
viewing with Microsoft Tree Viewer, 500–504
Microsoft Excel. See Excel
Microsoft Internet Information Services. See IIS
Microsoft Mining Content Viewer
finding detailed data in, 504–505
viewing raw data mining data with, 499
Microsoft Naïve Bayes algorithm
about, 473–474
attribute characteristics of, 507–508, 509
attribute discrimination, 508, 510
attribute profiles for, 506–507
dependency network viewer, 505–506
reviewing results of, 505–509
sample exercise using, 494–495
Microsoft Neural Network algorithm
about, 480–481
discrimination viewer for, 515
sample exercise using, 495, 497
viewing, 512
Microsoft SQL Server. See SQL Server 2000; SQL Server 2005
Microsoft Time Series algorithm, 479–480, 517
Microsoft Tree Viewer, 500–504
Decision Tree tab of, 500–502
Dependency Network tab of, 502–504
Microsoft Visual Basic.NET, 579
Microsoft Visual FoxPro, 23
Microsoft Visual Studio 2005. See Visual Studio 2005
Microsoft Visual Studio for Applications dialog box, 232
Migration Wizard, 264–265
Mining Accuracy Chart
about, 520
Classification Matrix, 532–533
Column Mapping tab, 520–521, 523, 525
creating testing data set, 522, 523
deleting column mapping on, 522, 524, 525
filtering data for test data set, 521
Lift Chart, 525–530, 531
mapping test data to mining model, 522, 524–525
predictable columns, 521
Profit Chart, 530–532
Select Data Mining Structure window, 521
Select Input Table window, 521
Mining Model Prediction tab, 538
Mining Model tab
Data Mining Query Task Editor, 181
Data Mining Query Transformation Editor dialog box, 212, 213
Mining Structures page (Role Design tab), 410
Model Item Security page (Report Model Properties dialog box), 666
models. See data mining models; Report Model; UDM
MOLAP (multidimensional OLAP) systems
about, 51–52, 56
partition storage options in, 359–361, 362–363
Multicast transformation, 223, 225
Multidimensional Connection 9.0 dialog box, 723, 724
multidimensional databases, 48
Multidimensional Expression language. See MDX language
Multidimensional OLAP systems. See MOLAP systems
multiline comment terminator (*/), 448
My Reports roles, 644