U


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



Professional SQL Server Analysis Services 2005 with MDX
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
Year: 2004
Pages: 176

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net