F


fact dimensions, 312

fact tables. See also tables

adding to data marts, 275–276

columns added to, 276

designing ManufacturingFact table, 112

identifying, 291–292

ManufacturingFact, 112, 122, 126

populating data mart, 277–286

SalesFact table, 35

storing measures in, 32, 35–37

FactLoad.dstx package

Control Flow tab for, 287

Load InventoryFact data flow task, 285, 286

LoadDimBatch data flow task for, 278–279, 281

feedback information

defined, 6

organizational timing of, 17

role in decision making, 9–11

fields

and field lists in Report Builder, 669, 670–671

hiding field lists on pivot tables, 732

retrieved for PivotTable and PivotChart Wizard, 725

Fields List (Report Builder), 670–671

file share delivery option for subscriptions, 654

File System task, 174–175, 184–185

files. See also text files

column markers for flat, 199

customizing default locations of, 82

downloading sample book, 155, 278

flat, 281–282

RDL, 561, 603

FILTER function, 432–434, 435

Filter Members dialog box, 492, 493

filtering

MDX SELECT statements, 432–434

data mining test data set, 521

values in prediction join query, 541, 542

Filters tab (Table Properties dialog box), 587

Find Results window, 73

finding

data with exact matches, 220–222

decision makers' needs, 100–101

detailed data in Microsoft Mining Content Viewer, 504–505

groups of nonexact matches in strings, 214

position of comparison cells, 395–396

relative hierarchy position within level, 397–399

rows based on nonexact matches, 213–218

values using fuzzy matching logic, 218–219

FirstChild function, 399, 400

FirstSibling function, 399, 400

fixed-width format, 198

Flat File Connection Manager Editor dialog box, 197, 198, 199

Flat File destination, 241–242

Flat File source, 197–200

flat files

column markers for, 199

connecting to data mart as data source, 281–282

floating windows, 75–76

flow path arrows, 154

folders

browsing contents with URL access, 687

creating role assignments for, 645–647

Home, 641, 646–647

Report Catalog, 628

RMUpload, 635, 637

uploading items to Report Server, 637

Fonts and Colors options (Options dialog box), 80, 81–82

footers for reports, 582, 585, 607–608

For Loop container, 171–172

Foreach Loop container, 173–175

foreign keys relationships

creating, 123–126

dimension tables identified by position in, 292

fact tables identified by position in, 291

forepersons, 19

Format Axis dialog box, 739, 740

Format Chart Area dialog box, 740

Format Data Series dialog box, 740, 741

formatting

chart area for pivot charts, 739–740

data series for pivot charts, 740, 741

measures, 305

properties of matrix reports, 559–563

text for reports, 606–607

URL-rendered reports, 691–700

forms-based security systems, 640

foundation information

defined, 6

organizational timing of, 17

FROM clause

MDX, 424

DMX, 546

FTP task, 185–186

functions. See also specific functions by name

MDX, 450–454

date, 251

mathematical, 249

null, 251

string, 250

Fuzzy Grouping transformation, 213–218, 219

Fuzzy Lookup transformation

Lookup transformation vs., 220–221

using, 218–219




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