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

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




Delivering Business Intelligence with Microsoft SQL Server 2005
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors: Brian Larson

Similar book on Amazon

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