M


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



Professional SQL Server Analysis Services 2005 with MDX
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
Year: 2004
Pages: 176

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net