A


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




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

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