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

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




Delivering Business Intelligence with Microsoft SQL Server 2005
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors: Brian Larson

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net