S

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