accounting system for Max Min, Inc., 23
actions
about, 349–350
client software support for, 352
creating, 350–352
defined, 349
drillthrough, 350, 351–352
report, 350, 352
types of, 350
ActiveX object downloads, 638–639
ActiveX Script task, 177–178
Add to Source Control check box (New Project dialog box), 65, 66
additive measures, 300, 303
administration utilities (Report Server), 563–564
AdomdCommand, 675
AdomdConnection, 675
AdomdDataReader, 675
ADOMD.NET
about, 674, 718
AdomdCommand, 675
AdomdConnection, 675
AdomdDataReader, 675
CellSet structure, 676
structure of, 674–676
using MDX query results with, 677–683
ADO.NET
data destination connections with, 240
data source connections with, 195–196
structure of ADOMD.NET and, 674
Advanced Editor for Import Column dialog box, 220
Advanced Editor for OLE DB Command dialog box, 226
Advanced Editor for Pivot dialog box, 228
Advanced Editor for Row Count Transformation dialog box, 229
Advanced Editor (Raw File Source dialog box), 202, 203
Advanced tab
Dimension Data page, 411–412
Fuzzy Grouping Transformation Editor dialog box, 217
Lookup Transformation Editor dialog box, 221
Term Extraction Transformation Editor, 237
AGGREGATE function, 453
aggregate functions, 579–580, 581. See also Sum aggregate function
in MDX SELECT statements, 444–445
grouping totals with Sum, 579–580, 581
setting Aggregate property for measure's, 300–301
specifying scope of, 596
used with measures in OLAP cube, 302–303
Aggregate transformations, 203–204, 205
aggregates. See also aggregate functions; Sum aggregate function
defined, 28, 46
preprocessed, 48–49
aggregation design
completed, 368
defined, 366
Aggregation Design Wizard
launching, 366
Set Aggregation Options page, 368–369
Specify Object Counts page, 367
Aggregations column, 352, 353
algorithms for data mining, 472–481. See also specific algorithms
analyzing discretized values, 492
Microsoft Association algorithm, 476–477
Microsoft Clustering algorithm, 474–476
Microsoft Decision Trees, 472–473
Microsoft Naïve Bayes algorithm, 473–474
Microsoft Neural Network algorithm, 480–481
Microsoft Time Series algorithm, 479–480,517
AMO (Analysis Management Objects), 674
ampersand (&), 389
Analysis Services
accessing data mart to populate and update cube, 288
aggregate functions for cube measures, 302–303
Analysis Services Execute DDL task, 178
Analysis Services Processing task, 178, 179
creating project in, 64–66, 67
fact dimensions in, 312
linking objects to cube, 338–340
query buttons for, 90
Sales Analysis Services cube, 129
sending data from data mart to cube, 96, 97
Analysis Services database
defining cube's security, 403–414
deploying project, 323
processing, 323
selecting as data source for pivot table, 724
Analysis Services Deployment Wizard
changing configuration information in, 322–323
deploying projects from, 330–336
sample project deployment from, 336–338
Ancestor function, 401–402
Appearance tab (Edit Chart Value dialog box), 620
applications. See also client software; Prospect Analyzer sample application; Report Manager web application
building front end web, 702–704
incorporating MDX query result into, 677
managing connections to clients with AdomdConnection, 675
architecture
data mart star and snowflake, 105–106
maintenance of UDM, 60
archiving OLTP data, 28–29
ascending sort order in Report Manager, 636–637
ASP.NET
MaxMin.com application in, 22
Report Server web service in, 565
Reports website in, 564
AssignExpression property, 171–172
association
about, 466–467
Microsoft Association algorithm for, 476–477
Microsoft Decision Trees algorithm for, 472–473
segmentation and classification with, 467
attribute characteristics viewer, 507–508, 509
attribute discrimination viewer, 508, 510
attribute profiles viewer, 506–507
attributes
adding name attributes to MDX scripts, 388–389
attribute columns in dimension table, 38
defined, 37
designing for data marts, 37, 104–105, 111
expanding dimension to view, 292
historical, 234
illustrated, 38
key dimension, 293, 308–309
parent, 313
audit columns, 204–206
authenticating data sources, 288
auto hide for windows, 78
AutoFormat
formatting manually before applying, 734
illustrated, 736
using, 734–735
auto hide setting (Toolbox window), 69–70
automatic MOLAP data storage, 362–363
autoregression tree, 480
AXIS(n) query dimension, 446–447