UDFs (user-defined functions). See also specific kinds
COM-based, 321, 322-326
COM-based versus .NET-based, 321-322, 338
dimension security approach using, 681-683
.NET assemblies (stored procedures), 81, 321-322, 325-338
UDM (Unified Dimensional Model). See also cubes
analyzing data using Data Analyzer, 557-563
architecture, 17-18, 144
cell writeback, 341
creating a report model from, 630-632
creating reports based on, 604-624
as a cube, 341
cube tuning, 430-437
design optimization, 424-437
dimension tuning, 424-430
dimension writeback, 246-249, 341-353
key elements, 17
OLAP world and, 145
overview, 17-18, 143-145
perspectives, 144, 173-175, 176-178
relational reporting and, 121
relational world and, 145
unary operators
Adventure Works example, 221-222
business scenario illustrating, 219-221
empty, 218
table summarizing, 218
UnaryOperatorColumn property, 218, 219
unbalanced hierarchies, 9
Unified Dimensional Model. See UDM
Union function (MDX), 783-784
.UniqueName functions (MDX), 784-785
.UnknownMember function (MDX), 785
UnknownMember property, 227
Unorder function (MDX), 208, 785-786
Unrestricted permission set, 333, 386
UPDATE CUBE statement (MDX), 358-359
updating dimension members. See dimension writeback
updating measure values. See cell writeback
Upgrade Advisor, 24-27
upgrading to Analysis Services 2005
installing without a test machine, 27-28
migrating your databases, 28-31
running the Upgrade Advisor, 24-27
testing the upgrade process on a test machine, 27
URL actions
browsing, 285-287
creating, 282-285
described, 281
Invocation property, 285
target types, 282
usage-based aggregation design, 458-463
Usage-Based Optimization Wizard, 460-463
USE LIBRARY syntax, 325
USE_EQUAL_ALLOCATION keyword, 361, 362
USE_EQUAL_INCREMENT keyword, 364
user-defined functions. See UDFs
username detection, 665
UserName function (MDX), 689, 786
users. See also access permissions
adding as an administrator, 369
of reports, security settings for, 625, 627
USE_WEIGHTED_ALLOCATION BY keyword, 362
USE_WEIGHTED_INCREMENT keyword, 364