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