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