ManagedCodeEnabled feature, 398
many-to-many dimensions, 260-262
many-to-one relationships between attributes, 427
matrix reports, 600-601. See also Reporting Services
Max function (MDX), 755
MaxThreads property, 444
MDAC (Microsoft Data Access Components), 93
.mdx files, 58
MDX (Multi-Dimensional eXpressions). See also MDX scripts; specific statements and functions
accessing COM UDFs in queries, 326
calling stored procedures, 335-336
clauses, defined, 70
comments, 79
cube security expressions, 686-688, 689-690
defined, 21, 58, 61-62
Excel generation of queries, 529-533, 535-536, 538-539
expressions, 78-79
file extension for saved queries, 58
functions overview, 81-88
fundamental concepts, 62-70
named queries, 105
named set creation in queries, 186-187
operators, 79-81
optimizing queries, 469-473
parameterized queries, 205-206
polling query technique for proactive caching, 648-649
query builder for reports, 607-608
query editor, 58-60
querying calculated measures, 173
querying each measure in a measure group, 253
querying stored procedures, 334-335
Rank function, 76
retrieving children members, 128
retrieving data from cells, 67-68
Statement command, 125
statements generated by the OWC, 153-156, 162-163
syntax for queries, 58, 70-71
UDM and, 17
URL action expression, 284-285
XML/A requests, 125-126
MDX scripts. See also calculations
CALCULATE statement, 183-184, 185
cell calculations, 191-195
changing cell values in, 196
cube space and, 189-190
debugging, 182, 267-272
default created by Analysis Services, 185
default created by Cube Wizard, 183
overview, 181, 182-183
recursion and, 196
scope of named sets and, 187
semicolon separating statements in, 182
MDX Solutions (Spofford), 208, 473
measure groups
cell writeback and, 356
changing relationships with cube dimensions, 156-157
defined, 43-44, 57, 62
EXISTS function with, 199
fact table columns and, 164
granularity attribute, 157
IgnoreUnrelatedDimensions property, 253-254
linking between cubes, 256-257
logical groups of measures in, 253
MeasureExpression property, 254-256
multiple per cube, 252-254
optimizing, 430
processing cubes and, 375
querying each measure in, 253
reference relationships, 158-161
relationships between dimensions and, 259-263
relationships between fact tables and, 164
security measure groups, 679-681
tradeoff between database size and performance, 449
types of relationships with cube dimensions, 157-158
uses for, 62
MeasureExpression property, 167, 254-256
MeasureGroupMeasures function (MDX), 207, 253, 755
measures. See also measure groups
adding to cubes, 167-169
calculated, 170-173
defined, 164
grouping logically in measure groups, 253
multiple, viewing in Excel pivot tables, 539-540
overview, 163-164
querying each in a measure group, 253
selecting for Data Analyzer, 558, 559
semi-additive, 294-296, 620, 621
updating values (cell writeback), 341
measures dimension, calculated members on, 76
Measures object, 62
Median function (MDX), 755
member functions (MDX), 85-86
MEMBER keyword in WITH clause, 75
members. See also calculated members
adding to dimensions, 345-348
All member, 226
default, of hierarchies, 226-227
deleting from a dimension, 351-353
filtering, on axes, 203
functions returning, 698
grouping in Excel pivot tables, automatic, 535
grouping in Excel pivot tables, custom, 540-542
grouping to form a single member, 229-230
of a level, defined, 130
member property approach to dimension security, 677-679
modifying data in a dimension, 348-351
names for, 65-66
ordering dimension members, 225
overview, 64-66
sorting members of a level, 130-132
viewing properties, 129-130
Members function (MDX), 756
.Members functions (MDX), 756, 757
MemberToStr function (MDX), 87, 756
MemoryLimit server property, 447, 474
merging partitions, 384-386, 432-434
metadata, UDM and, 17
Microsoft Association algorithm, 489
Microsoft Cluster Services (MSCS), 417-418
Microsoft Clustering algorithm, 488
Microsoft Data Access Components (MDAC), 93
Microsoft Data Analyzer
analyzing UDM data using, 557-563
connecting to AS2005, 557-558
drill down and up, 560-562
overview, 556-557
selecting dimensions to include, 558, 559
specifying measures to include, 558, 559
startup page, 557
visualizing data in, 562, 563
Microsoft Decision Trees algorithm, 488
Microsoft Excel. See also pivot tables (Excel)
Chart Wizard, 544, 546
external functions from, 321
Pivot Table and Pivot Chart Wizard, 522-523, 526
Microsoft Linear Regression algorithm, 490
Microsoft Logistic Regression algorithm, 490
Microsoft Neural Networks algorithm, 490
Microsoft OLE DB Provider for SQL Server, 35-36
Microsoft SQL Server 2000 Analysis Services Operations Guide (Rabeler and Wickert), 439
Migration Wizard, 14, 28-30, 31
Min function (MDX), 757
Mining Legend dialog, 500
mining model editor
Mining Accuracy Chart view, 501-504
Mining Model Prediction view, 505-506
Mining Model Viewer view, 499-500, 508-511
Mining Models view, 497, 507-508
Mining Structure view, 496-497, 518
OLAP mining model in, 518
overview, 496-498
Mining Model viewer, 499-500
Mining Models. See also relational mining model
defined, 34
objects, 57
OLAP, 512-519
Mining Models folder, 34
mining structure objects, 57
minus sign or hyphen (−)
as arithmetic operator, 79
for MDX comments, 79
as set operator, 79
as unary operator, 218, 219
MIS AG client tools, 564
Miscellaneous folder, 34
MOLAP (Multi-dimensional OLAP) storage mode
Analysis Services support for, 437
cache created by UDM, 17
dimension data retrieval and, 228
incremental processing and, 442
overview, 15
partitions and, 312-313, 431-432
performance and, 438, 447, 638
proactive caching and, 638-642, 644-645, 648, 651-655
real-time data and, 638
relational data sources and, 441
scheduled MOLAP option, 648
MSCS (Microsoft Cluster Services), 417-418
MTD function (MDX), 758
Multidimensional Connection 9.0 dialog (Excel), 524-525
multi-dimensional databases. See also databases
creating a report model from, 629
OLAP based on, 8-9
relational databases versus, 4, 11
Multi-Dimensional eXpressions. See MDX
Multi-dimensional OLAP storage mode. See MOLAP storage mode
multi-level hierarchies. See Parent-Child hierarchies