Safe permission set, 333, 386
Save As dialog (Excel), 550, 551
scalability
average query response under load, 422-423
handling large dimensions, 475
optimizing, 473-475
queues and, 421-422
scale out solution, 475
scale up solution, 475
server configuration properties and, 473-475
typical graph for server, 421-422
schemas
BIDS Discover requests for information, 126
snowflake, 12, 116
star, 11, 116
scope. See also SCOPE statements (MDX)
of COM UDFs, 324
of named sets, 187
SCOPE statements (MDX)
cell calculations using, 193-195
cube space restricted by, 190-191, 197
nested, 190
overview, 774
recursive calculations and, 196
syntax, 190
Script task (Integration Services), 579
security. See also access permissions; dimension security
cell security scenario, 684-691
for cube data, 683-691
defined, 659
enabling and disabling features, 398-399
importance of, 659
managing, 397-399
overview, 316, 659
for remote partition, 310-311
for reports, 625-628
roles, 397-398
server and database roles, 397-398
for source data, 660-662
stored procedures (assemblies) and, 321-322, 386
Surface Area Configuration utility for, 398-399
Security Settings dialog (Internet Explorer), 551-552
segmentation data mining algorithms, 488, 489
SELECT statement (DMX), 506-507
SELECT statement (MDX). See also specific clauses
for Analysis Services Report, 607-608
AUTO EXISTS behavior and, 190
axis specification, 71
Excel generation of, 529-530, 532-533, 535-536, 538-539
generated by the OWC, 154-156, 162-163
for incremental processing query after polling, 648
named sets in, 187
querying calculated measures, 173
querying stored procedures, 334-335
in SUB-SELECT clause, 200
syntax, 58, 70-71
verifying results of cell calculations, 192
SELECT statement (SQL), 599-601
Semantic Model Description Language (SMDL), 629
semi-additive measures, 294-296, 620, 621
semicolon (;) separating statements in MDX scripts, 182
Send Mail task (Integration Services), 566, 572-574
sequence analysis data mining algorithms, 488
Sequence Clustering algorithm, 489
Server Assemblies objects, 58
server configuration properties, 473-475
server role, 302-303
Server Time dimension
browsing hierarchies, 244-246
creating, 241-244, 245
uses for, 116
servers. See also specific kinds
average query response under load, 422-423
connection for AMO application, 407
disconnecting after AMO application, 409
managing, 368-370
Production Servers versus Test Servers, 368
registering with SSMS, 54-55
roles, 397-398
typical scalability graph, 421-422
set functions (MDX), 83-85. See also specific functions
set operators (MDX), 79-80
SET statement (MDX), 154-156, 162
SetDefaultMember dialog, 222
sets
constructing explicitly, 702-703
defined, 69, 74
duplicate tuples in, 70
empty, 69
functions returning, 698-699
generated by the OWC, 154-156, 162, 163
named, 74-75, 186-187
overview, 69-70
SetToArray function (MDX), 774
SetToStr function (MDX), 774-775
Shared Data Sources folder, 598
.Siblings function (MDX), 776
SilenceInterval property, 651-654
SilenceOverrideInterval property, 651-654
slash (/)
as arithmetic operator, 79
for MDX comments, 79
as unary operator, 218
Slice property, 435-437
slicer dimensions, 72-74
slicing cubes, defined, 521
SMDL (Semantic Model Description Language), 629
snowflake dimensions, 135-136, 342
snowflake schema, 12, 116
SOAP Envelope tags for XML/A, 373
sorting
Adventure Works examples, 203-205
dimension members, 225
improving performance with NonEmpty function, 471-472
members of a level, 130-132
Order function for, 761-765
preserving hierarchy, set containing multiple dimensions, 764-765
preserving hierarchy, set containing one dimension, 763-764
Sousa, Ryan (Corporate Information Factory), 13
speed. See performance; performance optimization
Spofford, George (MDX Solutions), 208, 473
SQL injection, 205, 350
SQL Profiler
administrator privileges needed for tracing events, 476
analyzing performance using, 476-480
checking aggregation utilization, 479-480
described, 14
SQL Server 2005 release and, 22
SQL Server 2005. See also SSMS (SQL Server Management Studio)
Analysis Services installation and, 440-441
data sources supported from, 91
services included in, 14
square brackets ([])
in MDX syntax, 70
in member names, 65
SSIS (SQL Server Integration Services). See Integration Services
SSMS (SQL Server Management Studio). See also administering Analysis Services
cell writeback and, 365
command for merging partitions, 385-386
connecting to services, 54-55
described, 14, 22, 54, 368
Object Explorer pane, 54, 55-58
registering servers with, 54-55
for remote partition, 309
Standard dimension, 114
star schema, 11, 116
starting
Aggregation Design Wizard, 314
Analysis Services 2005, 368
BIDS, 31
Business Intelligence Wizard, 231, 236, 246, 297
Cube Wizard, 44, 145
Data Mining Wizard, 492, 513
Data Source View Wizard, 40
Data Source Wizard, 36
debugging mode, 267
Dimension Wizard, 113, 241
MDX query editor, 58
Merge Partition dialog, 385
Migration Wizard, 28
Partition Wizard, 304, 382
Pivot Table and Pivot Chart Wizard (Excel), 522
Process dialog, 371
Report Wizard, 598, 605
Synchronize Database Wizard, 392
Upgrade Advisor, 24
Usage-Based Optimization Wizard, 460
Statement actions, 281
Statement command (MDX), 125
static versus non-static functions, 331-332
StdDev function (MDX), 776
StdDevP function (MDX), 776
stopping Analysis Services 2005, 368
storage modes. See also specific storage modes
Analysis Services support for, 437-438
cell writeback and, 358, 360
choosing, 17, 228, 312-313, 438
overview, 15-17
partitions and, 312-314, 315, 431-432
performance and, 438, 447
proactive caching and, 638-642, 644-645, 648, 651-656
Storage Options dialog
enabling proactive caching, 645-646
Latency option, 654-655
polling query option, 648-649
real-time ROLAP and, 656, 657
SilenceInterval option, 654
SilenceOverrideInterval option, 654
for timed updates, 649-650
StorageMode property, 165
stored procedures. See COM (Component Object Model) UDFs; .NET assemblies
string manipulation functions (MDX), 87. See also specific functions
strings, functions returning, 697
StripCalculatedMembers function (MDX), 777
StrToMember function (MDX), 87, 777
StrToSet function (MDX), 777-778
StrToTuple function (MDX), 778
StrToValue function (MDX), 779
subcubes
CREATE SUBCUBE statement for, 197-198
DROP SUBCUBE statement for, 198
EXISTING keyword and, 199-200
SUB-SELECT clause for querying, 200-201
WHERE clause and, 199
subject orientation of data warehouses, 4
subscriptions for reports, 628
SUB-SELECT clause (MDX), 200-201
Subset function (MDX), 779
Sum function (MDX), 165, 779
Surface Area Configuration utility, 398-399
synchronization
credentials for, 395-396
from default instance to new instance, 392-395
defined, 392
Synchronization Progress page for, 396
Synchronization command, 395
Synchronize Database Wizard, 392-395