Delivering Business Intelligence with Microsoft SQL Server 2005

Index 771

rows

counting number in data flow, 226–227

executing OLE DB command for each,

223–224

grouping table, 585–586

removing those with duplicate sort keys, 236

repeating on report pages, 582, 585

selecting Fuzzy Grouping model, 213–214

sorting in data flow, 235–236

splitting data based on number desired,

227, 230

viewing in Browse window, 328, 329

ROWS query dimension

slicer dimension with, 432

using with MDX SELECT statement, 444

using, 445–446

rs: prefixes, 692

RSReportServer.config file, 563

Rules viewer for Microsoft Association algorithm,

514–515, 516

S

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

772 Delivering Business Intelligence with Microsoft SQL Server 2005

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

ServerReport:ReportPath property, 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