.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