A

.abf files, 390

access permissions. See also dimension security; roles; security

adding a user as an administrator, 369

for COM (Component Object Model) UDFs, 325

for cubes and dimensions, 316-319

dimension writeback and, 342

for local cubes, 547

for reports, 625, 627

for stored procedures, 327, 333, 386

Account intelligence

browsing cubes and, 235

deploying changes, 234

described, 230

mapping account types, 231-232, 233

modifying, 232, 234

actions

defined, 281

drill-through action, 289-293

Report actions, 287-289

target types for, 282

types of, 281

URL actions, 281, 282-287

ActiveX controls, enabling, 551-552

ActiveX Data Objects for Multi-dimensional Databases. See ADOMD.NET

Add Analysis Service Connection Manager dialog (Integration Services), 569-570

Add Cube Dimension dialog, 158-159

Add Reference dialog, 329, 330

Add SQL Server Analysis Services Object dialog, 578

AddCalculatedMembers function (MDX)

Excel generation of, 530-531, 533, 536

overview, 703-704

Add/Remove Tables dialog, 95-97

ad-hoc reports

creating using Report Builder, 632-635

report model for, 629-632

administering Analysis Services

adding a user as an administrator, 369

adding assemblies to Analysis Services, 411-414

AMO (Analysis Management Objects) for, 402-409

assembly management, 386-389

backup and restore, 389-391, 410-411

changing Analysis Services properties, 369-370

creating partitions, 382-384

fail-over clustering and, 417-418

HTTP connectivity, 414-415

legacy DSO applications, 415-417

managing Analysis Services objects, 370-371

merging partitions, 384-386

online mode for, 399-400

processing database objects, 371-381

processing databases, 403-409

Production Servers versus Test Servers, 368

programming for, 402-414

security management, 397-399

server management, 368-370

SQL Server tools for, 367-399

synchronization, 392-396

ADOMD.NET (ActiveX Data Objects for Multidimensional Databases)

ADOMD Server stored procedures, 330-331

described, 15, 322

querying KPIs using, 279-280

Aggregate function (MDX), 704-705

aggregate functions, 165-167, 620

AggregateFunction property, 165, 295

Aggregation Design Wizard, 314-316, 450-454

AggregationPrefix property, 165

aggregationss

aggregate functions, 165-167

Aggregation Design Wizard for, 314-316, 450-454

applying aggregation design, 456-458

avoiding excessive design, 441, 449

building for partitions, 314-316

checking utilization of, 479-480

creating, 450-454

in cubes, 10, 11

custom, for reports, 620-623

defined, 7, 10, 314

design algorithm, 464, 466

design options, 464-469

designed, code example for, 454-455

of measures along dimensions, 111

OLAP and, 448

OLAP mining models for, 512-519

overview, 448-449

partition fact count and, 449

partitioning data and, 432

performance and, 441

properties controlling, 467-469

properties of cubes relating to, 165

relationships between attributes, 465-466

rigid versus flexible, 466

speed and, 10

usage-based design, 458-463

using hints for efficiency, 464

validating, 316

AggregationUsage property, 467, 468-469

algorithms

aggregation design, 464, 466

data mining, 485, 487-490, 492-493, 513, 514

All member, 226

AllMemberAggregationUsage property, 467-468

.AllMembers functions (MDX), 705-706

allocation for cell writeback

equal allocation, 361-362

incremental allocation, 363-364

weighted allocation, 362-363

Allow AdhocOpenRowSetQueries feature, 398

AMO (Analysis Management Objects)

adding assemblies to Analysis Services, 411-414

assembly properties set up by, 388

backup and restore using, 410-411

connecting to the server, 407

creating a console application, 406-409

described, 15, 328, 402

directives for, 406

disconnecting from the server, 409

namespace for, 406

Process dialog use of, 372-373

processing Analysis Services databases using, 403-409

SSMS management tasks and, 371

stored procedures, 328-330

Analysis Services 2000

Analysis Manager, 22

AS2005 versus, 22-24

backup file size limitation, 390

calculation model, 181, 182

data sources, 90-91

drill-through and, 280-281, 289

legacy DSO applications, 415-417

limitations of, 23, 90-91

migrating databases to AS2005, 28-31

upgrading to AS2005, 24-31

USE LIBRARY syntax, 325

Analysis Services 2005. See also administering Analysis Services; specific components and tools

adding assemblies, 411-414

architecture, 14-17

AS2000 versus, 22-24

calculation model, 181, 182

configuring instances, 368

connectivity components, 15

described, 3

Excel integration with, 522

fail-over clustering and, 417-418

HTTP connectivity, 414-415

legacy DSO applications with, 415-417

migrating databases to, 28-31

as part of SQL Server 2005, 14

restarting, 368

SQL Server installation and, 440-441

starting, 368

stopping, 368

upgrading to, 24-31

USE LIBRARY syntax and, 325

Analysis Services Processing task (Integration Services), 576-579

Analysis Services Report

automating delivery of, 628-629

calculated measures for, 611-612

changing the MDX query, 611-614

custom aggregates for, 620-623

deploying, 623-624

designing, 605-610

enhancing, 610-620

execution settings, 625-626

filtering, 613-614

formatting, 617-619

previewing, 617, 622-623

re-designing, 614-617

security settings, 625-627

showing profit in red or green, 617-619

using extended properties, 619-620

analyzing cubes with Office client components. See also pivot tables (Excel)

Microsoft Data Analyzer, 556-563

pivot tables (OWC), 550-556

Ancestor function (MDX), 706

Ancestors function (MDX), 706-707

AND operator (MDX), 80, 707

angle brackets (< >)

enclosing alias names, 75

as MDX comparison operators, 80

arithmetic operators (MDX), 79

AS keyword in WITH clause, 75

ASBackup package (Integration Services)

adding Execute DDL task, 568-572

adding Send Mail task, 572-574

creating, 567-568

debugging, 574-576

Ascendants function (MDX), 707

assemblies. See also COM (Component Object Model) UDFs; .NET assemblies (stored procedures)

adding stored procedures to, 332-334

adding to Analysis Services, 411-414

assembly objects, 57

defined, 34, 57

managing, 386-389

overview, 34, 57

Server Assemblies objects, 58

Assemblies folder, 34

assignments for cell calculations, 193-195

association data mining algorithms, 488, 489

Association Rules algorithm, 489

asterisk (*)

as arithmetic operator, 79

for MDX comments, 79

as set operator, 79-80

as unary operator, 218

attribute members action target type, 282

AttributeAllMemberName property, 226

AttributeHierarchyEnabled property, 132, 426-427

AttributeHierarchyOptimizedState property, 426

AttributeHierarchyVisible property, 132-133

attributes. See also relationships

calculations and, 182, 183

creating hierarchies from, 123-124

for data mining, discrete versus continuous, 484-485

defined, 34

dimension design and, 424

disabling, 132, 426-427

granularity attribute, 157

key attribute in dimensions, 121, 424-425, 427-429

KeyColumns property, 130

NameColumn property, 130

optimizing dimension attributes, 132-133

Parent-Child hierarchy, 141-142

properties controlling aggregation design and, 467-469

rarely used, turning off optimization for, 425-426

setting attribute hierarchy to invisible, 132-133

specifying dimension type, 157

specifying member properties, 122-123

table columns for dimensions and, 117

as two-level hierarchies, 121

unnecessary, avoiding, 425

AUTO EXISTS behavior

cube space and, 189-190

EXISTS function compared to, 190

null values and, 201-202

SELECT statement and, 190

automating administrative processes using XML/A

adding assemblies to Analysis Services, 411-414

backup and restore, 410-411

creating an AMO console application, 406-409

processing databases, 403-409

automating Integration Services packages

approaches to, 587

creating a scheduled job, 589-590

executing the scheduled job, 590-591

saving a package as an XML file, 587-589

automating report delivery, 628-629

average latency scenario for real-time cubes, 651-655

AverageOfChildren aggregate function, 295

Avg function (MDX), 708

axes, filtering members on, 203

axis dimensions, 66, 71

Axis function (MDX), 708-710