Sales Analysis Services cube, illustrated, 129
Sales data mart, 319
SalesFact table, 35
Save the Connection String to the Application Configuration File page (Data Source Configuration Wizard), 713
SaveCheckpoints property, 259
saving entries in SQL Server Management Studio Query window, 424
SCDs. See Slowly Changing Dimensions
scheduled MOLAP data storage, 363
Schema Generation Progress dialog box, 137
schemas
snowflake, 40, 41, 106, 107
star, 35–37, 41, 105, 106
scope of variables, 245
Script Component transformation, 227–230, 231
Script Editing window, 189
Script page (ActiveX Script Task Editor), 177
Script task, 186–188, 189
scripts. See also MDX scripting
defined, 91
defining VBScript or JScript, 177–178
executing .NET code with, 186–188, 189
using Script Component transformation, 227–230, 231
searching. See finding
SECTIONS query dimension, 445–446
Security Context dialog box, 413
security rights. See also roles
assigning roles for Windows groups, 647–648
customizing, 640
inherited, 647
linked reports and, 648, 649
Report Model, 663–665
Report Model and, 657
Report Server, 639–648
Reporting Services and, 639, 640, 642–643
required for execution snapshots, 653
restricting access to SQL Server Management Studio, 550
setting for OLAP cube, 403–414
subscriptions and, 655
security roles. See roles
segmentation
about, 465–466
classification and association with, 467
Microsoft Clustering algorithm for, 474–476
Microsoft Sequence Clustering algorithm for, 477–478,517
Select Case Level Columns page (Data Mining Wizard), 488, 490
SELECT clause (DMX), 545
Select Language dialog box, 373
Select Mining Model dialog box, 536
Select Mining Structure dialog box, 523
Select Objects page (Linked Object Wizard), 340
Select Processing Options page (Analysis Services Deployment Wizard), 333, 334
Select Source Cube Dimension page (Data Mining Wizard), 488, 489
SELECT statements (MDX), 425
Select Table dialog box, 524
Select the Case Key page (Data Mining Wizard), 488, 489
Select the Data Mining Technique page (Data Mining Wizard), 488
Select the Definition Method page (Data Mining Wizard), 487–488
Select the Image Source page (Image Wizard), 603
SELECT statements (MDX)
about, 422–423
aggregate functions in, 444–445
AXIS(n) query dimension for, 446–447
basic form of, 424–426
creating temporary calculated members with, 436–439
CROSSJOIN function in, 439–440
FILTER function with, 432–434, 435
NON EMPTY keyword in, 440–441
query dimensions in, 426–430, 445–447
slicer dimensions with, 430–432, 433
TOPCOUNT/BOTTOMCOUNT functions in, 441–444
WITH statements and, 435–439
semiadditive measures, 301–302, 303
sequence analysis
about, 467–468
Microsoft Sequence Clustering algorithm for, 477–478,517
Sequence container, 175–176
ScrverReport:ReportPath properly, 710
ServerReport:ReportServerUrl property, 710
servers
connecting from SQL Server Management Studio on start up, 83, 84
registering, 85–87, 88
Set Aggregation Options page (Aggregation Design Wizard), 368–369
Set Default Member dialog box, 391
set operators in MDX, 450
shared report data sources, 633–636
shortcuts for MDX scripting, 380–382
Shrink Database tasks, 169–170
Siblings function, 399, 400
single quotes (' '), 436
singleton queries
about, 534
creating, 534–537, 538, 539
illustrated, 537, 538, 539
as prediction query, 550
Slice Source Cube page (Data Mining Wizard), 494
slicer dimensions, 430–432, 433
slicing source cube, 485, 494
Slowly Changing Dimension Wizard, 230–234
selecting dimension table and keys, 231, 232
specifying columns in, 231, 233
specifying historical attributes, 234
Slowly Changing Dimensions (SCDs)
defining time periods for, 133
tracking salespeople in Sales data mart cube, 319
Type 1 SCD, 315–316
Type 2 SCD, 316–318
Type 3 SCD, 318–319
snapshots
execution, 653
report history, 654
snowflake schema
about, 40, 41, 106
illustrated, 107
Manufacturing data mart as, 113
Solution Explorer window
about, 66–68
combined in tabbed window, 77–78, 79
as floating window, 76
Solutions
creating, 64–66, 67
finding and opening, 63–64
with projects in SQL Server Management Studio, 91–92
Sort transformations, 235–236
sorting data in Report Manager, 636–637
Sorting tab
List Properties dialog box, 608, 609
Table Properties dialog box, 582, 584
source control in UDM, 60
Specify Columns' Content and Data Type page (Data Mining Wizard), 490, 491
Specify Configuration Properties page (Analysis Services Deployment Wizard), 333
Specify Mining Model Column Usage page (Data Mining Wizard), 490, 491
Specify Object Counts page (Aggregation Design Wizard), 367
Specify Options for Partitions and Roles page (Analysis Services Deployment Wizard), 331, 332
Specify Source Analysis Services Database page (Analysis Services Deployment Wizard), 330, 331
splitting data
based on number of rows desired, 227, 230
based on percentage, 224–225, 227
into multiple outputs, 208–210
SQL. See SQL Server 2005; SQL statements; T-SQL
SQL pane (Query Builder), 202
SQL Server 2000
executing DTS package for, 180–182
holding Reporting Services database in, 564
SQL Server 2005. See also Business Intelligence Development Studio; SQL Server Management Studio
holding Reporting Services database in, 564
items for transferring objects, 190
migrating DTS packages from SQL Server 2000 to, 264–265
opportunities of business intelligence with, 745–746
running statements or stored procedures for packages, 182, 184
running Transact SQL statements on, 165–166, 167
scope of order processing for Max Min in, 22
sending e-mail messages with SQLiMail, 167–168
support of business intelligence with, 12
SQL Server Agent, 564
SQL Server Books Online, 565
SQL Server destination, 242–243
SQL Server Integration Services Migration Wizard, 264–265
SQL Server Management Studio
about, 82
connecting to server, 83, 84
creating data mart database in, 115–117
creating dimension tables in, 117–121
creating DMX queries in, 550–552
default values for new foreign key relationships, 123
developing database with Business Intelligence Development Studio, 131
empty prediction queries in, 551–552
executing queries in query windows, 88, 90–91
expanding description area in, 118
Object Explorer window, 87–88, 89
opening MDX Query window, 423–424
Registered Servers window, 85–87, 88
restricting access to, 550
saving query entries in, 424
Summary window, 88, 90
supported projects in, 91–92
windows open by default in, 83–85
SQL Server Mobile destination, 243
SQL Server Reporting Services. See Reporting Services
SQL statements
aggregate transformations in, 203–204, 205
executing OLE DB command for each row of data flow, 223–224
loading portion of source lookup table into memory, 221
running for packages, 182, 184
SQLiMail, 167–168
square brackets ([ ]), 378
standard subscriptions, 654
star schema
about, 35–37, 41, 105
defined, 35
hierarchies for, 39
illustrated, 36, 106
Max Min Sales, 138
Start menu
Business Intelligence Development Studio on, 64
SQL Server Management Studio on, 83
Storage Options dialog box, 364, 365
stored procedure version of Query Builder, 613, 614
stored procedures
determining fields returned by, 613
running for packages, 182, 184
stp_InventoryByTypeByMonth, 612, 613
stp_InventoryByTypeByMonth stored procedure, 612, 613
string functions, 250
string literals, 246
string operators in MDX, 449
strings
enclosing named sets in single quotes, 436
finding groups of nonexact matches in, 214
string functions, 250
string literals, 246
string operators in MDX, 449
subproperties, 590
Subreport Properties dialog box, 623–624, 625, 626
subreports for charts, 622–625, 627
subscriptions
about report, 559–560
data-driven, 655–656
delivery options for, 654
multiple report, 654–655
standard, 654
subtotals on reports, 573
Sum aggregate function
additive measures and, 300, 303
grouping totals with, 579–580, 581
specifying scope of, 596
SUM function
format for, 415–416
using in MDX SELECT statements, 444–445
summary bands, 569
Summary window, 88, 90
syntax
MDX SELECT statement with two query dimensions, 428
for MDX tuples in expressions, 378
DMX prediction query, 545–547
FROM clause, 546
Report Server URL, 683–684
System Administrator role, 645
System User role, 645