F

fact relationships, 259-260

fact tables. See also tables

in Adventure Works sample project, 35

defined, 6

deleting dimension members and, 352

deleting entries from, 352

as de-normalized, 7

foreign keys, 6, 8

measure groups and columns of, 164

optimizing measure groups for, 430

overview, 7-8

relationships between fact and dimension members, 158

relationships between measure groups and, 164

fail-over clustering, 417-418

features, enabling and disabling, 398-399

Filter function (MDX)

eliminating null values with, 202

filtering members on axes, 203

improving performance with NonEmpty function, 471-472

overview, 84-85, 736

.FirstChild function (MDX), 737

.FirstSibling function (MDX), 737-738

Flat File Connection Manager Editor (Integration Services), 581-582, 583

Flat File Source Editor (Integration Services), 580-581, 582, 584

Flat File Source transform (Integration Services), 579-582

flexible aggregations, 466

folders

DisplayFolder property of cubes, 166

in Solution Explorer pane, 33-34, 598

ForceCommitTimeout server property, 439

ForceMultiPass server property, 474

foreign keys

in Adventure Works sample project, 35

integer keys for performance, 424-425, 440

overview, 6, 8

foreign languages. See translations

FORMAT_STRING extended property, 619-620

FormatString property, 167, 255-256

fraud detection using data mining, 487

Freeze statement (MDX), 196

Friendly Name property, 104, 105

FROM clause (MDX), 58, 72

Front Page 2003, creating OWC pivot tables using, 554-556

functions (MDX). See also specific functions

aggregate functions, 165-167, 620

alphabetical index to, 693-696

built-in COM UDFs, 322-323

calling, 82-83, 323, 331-332, 334

COM-based UDFs, 321, 322-326

dimension functions, 87

hierarchy functions, 87

level functions, 87

member functions, 85-86

miscellaneous functions, 87-88

.NET assemblies (stored procedures), 81, 321-322, 325-338

new with AS2005, 207-208

numeric functions, 86-87

overview, 81-82

return type index to, 696-700

set functions, 83-85

static versus non-static, 331-332

string manipulation functions, 87

uses for, 81