U

unbalanced hierarchy, 126

Unchanged Output, SCD Wizard, 119

Union All transformation

for breaking up execution tree, 367–368

for data grain changes, 174

Unpivot transformation

for creating rows from columns, 312–313

for data grain changes, 174

unprocess

for SSAS dimensions, 194

for SSAS mining structures and models, 196

for SSAS partitions, 195

Upgrade Advisor, 340–341

user-defined variables

creating, 22–24

retrieving in Script Components, 26

retrieving in Script Tasks, 24–26