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