D

Data Analyzer. See Microsoft Data Analyzer

Data Flow task (Integration Services)

adding Flat File Source transform, 579-582

adding Partition Processing transform, 580, 583-587

described, 566, 579

PipelineDataLoad package for, 579-587

transforms available for, 580

Data Flow Transformations (Integration Services)

available transforms, 580

described, 566, 579

Flat File Source transform, 579-582

Partition Processing transform, 579, 580, 583-587

data marts. See also specific elements

data warehouses versus, 5

defined, 5

key elements, 6-12

data mining. See also mining model editor; relational mining model

algorithms, 485, 487-490

Allow AdhocOpenRowSetQueries feature, 398

analyzing cubes with data mining dimensions, 518-519

analyzing the accuracy of, 500-504

in call centers, 487

creating mining models from cubes, 512-513

CRISP-DM process guide, 484

data mining dimensions, 262-263

Data Mining Wizard for, 492-496, 513-517

defined, 262

discrete versus continuous attributes for, 484-485

Discretized content, 498

DMX query language for, 506-507

fraud detection using, 486

increasing retail profits using, 486

Integration Services tasks for, 587

model analysis, evaluation, and validation, 483

model building, 485-486

multiple models in same structure, 507, 512

in the NBA, 486-487

OLAP mining models, 512-519

OLAP versus, 3

overview, 520

prediction using, 485-486, 504-507

process of, 481-486

requirements for, 482

targeted mailing type problem, 491-500

topic area understanding for, 484

training data set for, 485

understanding the data for, 484-485

uses for, 262, 481

validation data set for, 485

data mining dimensions, 262-263, 518-519

Data Mining Extensions (DMX) language, 506-507

Data Mining Wizard

for OLAP mining models, 513-517

for relational mining models, 492-496

data providers

.NET, 35, 93-94

OLE DB, 35-36, 93-94

data pump, 15

DATA PUMP component, 414-415

Data Source Designer page, 660-662

Data Source View Editor, 41-43

Data Source View Wizard, 40-41, 92

Data Source Views. See DSVs

Data Source Views folder, 33

Data Source Wizard

creating a data source, 36-38

remote partition data source configuration, 307-308, 309

data sources

in AS2000 versus AS2005, 90-91

authenticating connections, 660

connection properties, 92

creating, 35-38, 39

credentials for, 661

data providers for, 35

defined, 33

integration by the UDM, 144

multiple, within a DSV, 108-109

naming, 38, 39

.NET versus OLE DB providers, 93-94

objects, 56, 89

Operational Data Store (ODS), 89-90

overview, 89-91

relational, optimizing, 441

for reports, 598, 605-606, 625, 626

security, 660-662

service accounts for, 660

supported by AS2005, 91-92

username and password options, 660-661

Data Sources folder, 33

data types, processing speed and, 440

The Data Warehouse Lifecycle (Kimball, Reeves, Ross, and Thornthwaite), 13

The Data Warehouse Toolkit (Kimball), 135

data warehouses. See also specific elements

data marts versus, 5

defined, 3-4

Inmon's versus Kimball's approach to, 12-13

key elements, 6-12

Database Synchronization Progress page, 396

databases. See also data sources

adding COM UDFs to, 324-325

AnalysisServicesTutorial2005 database, 371-375

backup using stored procedure, 328-330

creating a report model from, 629

creating a report on a relational database, 597-604

ERDs for relational databases, 4, 5

making design changes after creating, 399-402

migrating to AS2005, 28-31

multi-dimensional versus relational, 4, 11

naming projects after, 399

objects, 56

OLAP based on multi-dimensional databases, 8-9

online mode (BIDS) for changing, 399, 400-402

processing database objects, 371-381

processing with AMO, 403-409

roles, 397-398

synchronization, 392-396

tradeoff between size and performance, 449

.DataMember function (MDX)

cube security using, 689

overview, 719-720

Dataset actions, 281

Date, C. J. (An Introduction to Database Systems), 135

DB2 (IBM), data sources supported from, 91

DDLs

for adding a member to a dimension, 347-348

Attributes section, 348

for backing up multiple databases, 390

Execute DDL task (Integration Services), 567-576

for modifying data of members in a dimension, 350, 351

Object section, 348

for processing dimensions, 443

sending using your own tool, 353

debugging Integration Services, 574

debugging MDX scripts

debugging windows, 267

executing one statement at a time, 269

MDX1 through MDX4 panes for, 271

overview, 182, 267-272

simulating a different user, 272

starting debugging mode, 267

toggling highlighting behavior, 269

debugging stored procedures, 332, 336-337

Decision Support Object (DSO), 15, 415-417

DefaultDrillthroughMaxRows server property, 475

DefaultMeasure property, 165

.DefaultMember function (MDX), 720

DefaultMember property, 222, 226-227

Delete Members dialog, 351

deleting or removing

calculated members, 188

clearing data in a cube, 376

cubes, 145

dimension data, 351-353

empty cells, 201-203, 469-471

fact table entries, 352

named sets, 187

subcubes, 198

tables from DSVs, 95-97

dependencies, processing database objects and, 374

deploying projects

custom rollups and, 217

to a different machine, 51

errors in Output window, 51-52

methods for, 50, 152

operations performed, 51, 152

reports, 623-624

to the same machine, 51

Deployment Wizard, 14

depreciation, custom rollups for, 210-212

Descendants function (MDX)

with AFTER flag, 721, 723

with BEFORE flag, 722, 723

with BEFORE_AND_AFTER flags, 723

with LEAVES flag, 723-724, 725

overview, 720-724

with SELF flag, 721, 723

with SELF_AND_AFTER flags, 722, 723

with SELF_AND_BEFORE flags, 722, 723

with SELF_BEFORE_AFTER flags, 723

dicing data, defined, 521

Dimension Designer

attributes in, 121-123

Browser pane, 126-128

defining translations in dimensions, 133-134

hierarchies and levels in, 123-124

overview, 120-121

viewing member properties, 129-130

dimension functions (MDX)

.Dimension, 724

Dimensions, 724-725

overview, 87

Dimension intelligence

described, 230

mapping dimension types, 239-240

using, 241

dimension members action target type, 282

dimension security. See also access permissions

access-role approach, 676-677

external function approach, 681-683

member property approach, 677-679

overview, 662-663

role object for, 663

scenario, 663-667

security measure group approach, 679-681

user-role approach, 667-676

dimension tables. See also tables

in Adventure Works sample project, 35

creating snowflake dimensions from, 135-136

defined, 6-7

overview, 8

primary keys, 8, 97-98, 99

relationships between fact and dimension members, 158

Dimension Wizard

creating a Parent-Child hierarchy, 140-141

creating a Server Time dimension, 241-244, 245

creating a Time dimension, 136-138

custom rollups example, 213

Geography Dimension example, 112-120

dimension writeback

adding a member, 345-348

BIDS support for, 341

Business Intelligence Wizard for, 247

business scenarios with uses for, 246

creating a dimension for examples, 342-345

DDLs for, 347-348, 350, 351, 353

defined, 341

deleting data, 351-353

limitations of, 353

modifying data of members, 348-351

named queries and, 342

overview, 246-249, 341

performance reduced by using BIDS for, 353

prerequisites for, 342

using, 248-249

dimensions. See also attributes; dimension security; hierarchies

access permissions, 316-319

Account intelligence, 230, 231-235

adding a member, 345-348

aggregation of measures along, 111

Auto build option, 114

browsing dimensions, 124-130

browsing reference dimensions, 162-163

conformed, 13

creating for writeback examples, 342-345

creating without attributes, 133

cube dimensions, 258

for currency conversion, 296

custom rollups, 210-218

customizing using properties, 225-230

data mining dimensions, 262-263, 518-519

as database dimensions, 258

defined, 8, 9, 34

defining translations in, 133-134

deleting data, 351-353

Dimension Designer for, 120-124, 126-130, 133-134

Dimension intelligence, 230, 239-241

Dimension Wizard for, 112-120

fact dimensions, 259-260

fine tuning, 424-430

functions returning, 699

incremental processing for, 442-443

intermediate, 260-261

key attribute, 121, 424-425

large, handling, 475

many-to-many dimensions, 260-262

measures dimension, 76

members, 64-66

modifying data of members, 348-351

objects, 57

optimizing attributes, 132-133

optimizing reference dimensions, 431

ordering members, 225

overview, 8-9, 34

Parent-Child hierarchies, creating, 139-142

Parent-Child hierarchies, enhancing, 218-225

prerequisites for updating, 342

processing, 379-381

reference relationships, 158-161

relationships between measure groups and, 259-263

role-playing, 264

selecting for Data Analyzer, 558, 559

Server Time, 116, 241-246

snowflake, 135-136, 342

sorting members of a level, 130-132

Standard dimension, 114

Time dimensions, 114, 136-139

Time intelligence, 230, 235-239

updating, 342-345

uses for, 112

writeback, 246-249, 341-353

Dimensions folder, 34

disabling

attributes, 132, 426-427

features, 398-399

Visual Totals in the OWC, 154

Discover requests for schema information (BIDS), 126

DiscretizationBucketCount property, 229-230, 498

DiscretizationMethod property, 229-230

DisplayFolder property, 166

Distinct function (MDX), 726

DistinctCount function (MDX)

Adventure Works example, 167-168

for aggregations, 166

overview, 87, 726

DLLs for COM UDFs

built-in UDFs, 322

created UDFs, 321, 324

DMX (Data Mining Extensions) language, 506-507

drill down

defined, 280

in Excel pivot tables, 536-539

in Microsoft Data Analyzer, 560-562

drill up

in Excel pivot tables, 537

in Microsoft Data Analyzer, 560

DrillDownLevel function (MDX), 530, 726-727, 728

DrillDownLevelBottom function (MDX), 727, 729

DrillDownLevelTop function (MDX), 728-729

DrillDownMember function (MDX), 539, 729-730

DrillDownMemberBottom function (MDX), 731, 733

DrillDownMemberTop function (MDX), 731-732, 733

drill-through, 280-281

drill-through action

in AS2000 versus AS2005, 289

enhancing Adventure Works example, 290-293

overview, 289

target types, 282

DrillUpLevel function (MDX), 732, 734

DrillUpMember function (MDX), 732, 735

DROP MEMBER statement (MDX), 188

DROP SET statement (MDX), 187

DROP SUBCUBE statement (MDX), 198

DROP VISUAL TOTALS statement (MDX), 153-154, 155, 162

DSO (Decision Support Object), 15, 415-417

DSV Designer

adding or removing tables, 95-97

All Tables diagram, 94-95

creating new diagrams, 102-103

customizing tables, 99-101

Diagram Organizer, 94, 102-103

pecifying primary keys, 97-98, 99

specifying relationships, 97, 98

DSV Editor, 41-43

DSVs (Data Source Views)

adding or removing tables, 95-97

changes retained in, 109

creating DSVs, 38, 40-41, 92

creating new diagrams, 102-103

customizing tables, 99-101

diagrams, defined, 101

DSV Designer, 94-101, 102-103

DSV Editor, 41-43

initial data analysis, 106-108

layouts, 105-106

multiple data sources within, 108-109

Named Query editor, 99-101

objects, 56

overview, 33, 94

properties, 103-105

specifying primary keys, 97-98, 99

specifying relationships, 97, 98

validating, 106

.dtsx files, 587