C


cached report expiration, 650

caching. See also report caching

enabling report, 651

IIS web page, 55–56, 57

proactive, 55–59

report, 648–652

UDM proactive, 55, 56–59

calculated measures

creating, 297–300, 303, 306

definitions stored in cube, 297

viewing definitions in MDX scripts, 299, 300

Calculated Member form, 298, 299

calculated members

creating temporary, 436–439

named sets vs., 437

providing without exposing underlying data, 413

Calculation Tools window, 299

Calculations tab (Cube Design tab), 298

CanGrow property for cells, 578

Cell Data page (Role Design tab), 405–406, 408

cells

about, 580–581

aggregate sets specified in MDX scripts, 385–387

CanGrow property for, 578

CellSet, 676

Current Cell identified with tuple, 397

designating ranges of, 333–334, 335

editing expressions for report detail, 578, 580

editing pivot tables labels for, 732, 734

finding position of comparison and current, 395–396

green triangle in corner of total, 596–597

identifying location of, 377–378

locating in tuples, 379–380

relative navigation of, 395–402

specifying groups in Excel, 387–388, 389

CellSet

pivot tables and viewed, 720

retrieving in Prospect Analyzer, 679–683

structure of, 676

CHAPTERS query dimension, 445–446

characters

character mapping, 206–208

fuzzy grouping for, 214

Chart Properties dialog box

Data tab, 618, 620

General tab, 619

illustrated, 619

Legend tab, 621, 623

modifying fonts with, 617

Preview tab, 622, 625

3D Effect tab, 621, 624

X Axis tab, 619, 621

Y Axis tab, 619, 621, 622

charts, 612–627. See also pivot charts

about, 611–612, 668

creating subreports for, 622–625, 627

including in body of reports, 616–618, 619

Check Database Integrity task, 163–165

CheckpointFilename property, 259

checkpoints, 259–260

CheckpointUsage property, 260

Children function, 399, 400

Choose a Data Source Type page (Data Source Configuration Wizard), 712

Choose Data Source dialog box, 722, 725

Choose the Embedded Image page (Image Wizard), 604

Choose the Table Layout page (Report Wizard), 575

Choose Your Data Connection page (Data Source Configuration Wizard), 712

Choose Your Database Objects page (Data Source Configuration Wizard), 714

classification

about, 463–464

association and segmentation with, 467

Microsoft Clustering algorithm for, 474–476

Microsoft Decision Trees algorithm for, 472–473

Microsoft Naïve Bayes algorithm for, 473–474

Microsoft Neural Network algorithm for, 480–481

Microsoft Sequence Clustering algorithm for, 477–478,517

Classification Matrix

about, 520

illustrated, 533

viewing, 532–533

clickthrough reports (Report Builder), 671

client software

actions with, 352

managing connections to with AdomdConnection, 675

support for KPIs, 346

client-side printing, 638–639

ClosingPeriod function, 453

cluster characteristics viewer, 511, 513

cluster diagram viewer, 509–510, 511

cluster discrimination viewer, 511

cluster profile viewer, 510–511, 512

Codd, E. F., 44

Collection page (Foreach Loop Editor), 175

Column Mapping tab, 520–521, 523, 525

column markers for flat files, 199

columns

adding to Browse window, 329

audit, 204–206

converting data type of, 210

copying existing, 210, 211

data mining data, 484, 485

derived, 212, 214

designating mapping for data mart population, 280,283–284

dimension table attribute, 38

exporting, 212, 215

extracting terms in freeform text, 236–238

fuzzy matching for, 215–216

importing, 220

indicating data type, 490, 491

inserting in fact table, 276

selecting data mining case level, 488, 490

specifying in Slowly Changing Dimension Wizard, 231, 233

specifying usage for data mining models, 490,491

testing mining models with predictable, 521

widening table, 574, 577

word or phrase lookup in data flow, 238, 239

COLUMNS query dimension

creating result with, 427–428, 430

slicer dimension with, 432

using, 445–446

Columns tab (Fuzzy Grouping Transformation Editor dialog box), 215–216

command parameters for URL-rendered reports, 686–687

comment operators in MDX, 448

comparison cells, 395–396

Completing the Wizard page (Report Wizard), 576

Component Properties tab (Advance Editor for DataReader Source dialog box), 195

Conditional Split transformations, 208–210

Configure Data Viewer dialog box, 263

Configure Error Output dialog box, 200, 208

Configure SSIS Logs dialog box, 254–256

Confirm Deployment page (Analysis Services Deployment Wizard), 333, 334

Connect to Server dialog box, 83

Connections tray, 143, 146

containers

defined, 171

For Loop, 171–173

Foreach Loop, 173–175

Sequence, 175–176

Content Manager role

about, 644–645

privileges required for Report Manager exercises, 628–629

Context menu

in Object Explorer window, 116

for precedence arrow, 151

control flow. See also Control Flow items

creating and editing tasks, 148–149, 150

defined, 143

defining event, 144–145

event handlers and, 251–252, 253

setting precedence among tasks, 150–154

storing tasks in connection managers, 149–150

Control Flow Designer tab

defining and specifying control flow tasks using, 148–149

dragging multiple data flow tasks onto, 278, 281,284

for FactLoad.dstx package, 287

illustrated, 143

Integration Services package structure on, 145

Control Flow items, 171–194

about, 180

ActiveX Script task, 177–178

Analysis Services Execute DDL task, 178

Analysis Services Processing task, 178, 179

Bulk Insert task, 179, 180

custom tasks, 194

Data Mining Query task, 180, 181

Execute DTS 2000 Package task, 180–182

Execute Package task, 182, 183

Execute Process task, 182, 183

Execute SQL task, 182, 184

File System task, 184–185

For Loop container, 171–173

Foreach Loop container, 173–175

FTP task, 185–186

items for transferring SQL Server objects, 190

Message Queue task, 186, 187

Script task, 186–188, 189

Send Mail task, 188–190

Sequence container, 175–176

Web Service task, 190–191

within Foreach Loop, 174–175

WMI Data Reader task, 191–192

WMI Event Watcher task, 192–193

XML task, 193–194

Control Flow Toolbox. See also Control Flow items; Maintenance Plan tasks

about, 162

areas of, 162

Control Flow items on, 171

pointer entries in, 163

Copy Column transformation, 210, 211

COUNT aggregate function, 444–445

Cousin function, 401–402

Create Directory for Solution check box (New Project dialog box), 65, 66

Create New Data Source dialog box, 722, 724

crossjoin (*) operator, 450

CROSSJOIN function

NON EMPTY, 441

using in MDX queries, 439–440

CSV report formatting, 694–695

Cube Wizard

creating cube in, 130–135

dimensions created by, 293, 294

identifying fact and dimension tables, 291–292

key attribute created by, 293

opening from Solution Explorer window, 290

previewing MaxMinSales cube in, 135

red asterisk in, 136

selecting measures in, 132

cubes

about, 34

actions added to, 349–352

aggregation design for, 366–368

building OLAP on transactional data, 59

calculated measures definition stored in, 297

creating multiple partitions from single table, 363–366

Cube Wizard for creating, 130–135

default dimension members in tuples, 383–385

defined, 46

defining on top of existing data mart, 286–294

dividing data with cube slice, 485, 494

dragging name of to Query Window SELECT statements, 425

enabling writeback for, 369–370

errors made while creating, 136, 138

executing MDX queries against, 422, 674

identifying cell locations, 377–378

illustrated, 34

KPIs added to, 346–349

linking objects to, 338–340

MaxMinSales, 135

measure groups in, 303, 304, 352–353

measures in, 294

navigational tools needed for, 376–377

perspectives for, 370–371

selecting data mining data columns, 484

setting for OLAP, 403–414

storage options for partitions, 359–363

templates for, 132

translating metadata in, 371–373

use in OLAP structures, 45–48

user-friendly names for hierarchies, 388–389, 390–394

Cubes page (Role Design tab), 405, 407

curly brackets ({ }), 386, 427

CurrentMember function, 397

Customer List with Prediction report, 601, 602, 604, 610, 611




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

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