HAVING clause (MDX), 203
Head function (MDX), 739
hierarchies. See also Parent-Child hierarchies
accessing cells in cube space and, 182
in Adventure Works sample project, 63
attribute hierarchies, 34
attributes as two-level, 121
avoiding unnecessary attributes, 425
completely balanced, 9
creating dimensions and, 119
creating from dimension attributes, 123-124
custom rollups applied to, 211, 212-217
default member, 226-227
defined, 9
defining relationships between attributes, 427-430
functions returning, 699
grouping members, 229-230
of KPIs, 276
for local cubes, 547-548
members, 64-66
in pivot tables (Excel), 527-528
in pivot tables (OWC), 552-554
preserving when sorting, set containing multiple dimensions, 764-765
preserving when sorting, set containing one dimension, 763-764
ragged, 9
setting attribute hierarchy to invisible, 132-133
terminology in this book, 34
unbalanced, 9
user hierarchies, 34
hierarchy action target type, 282
hierarchy functions (MDX)
Hierarchize, 531, 536, 739
.Hierarchy, 739
overview, 87
hierarchy members action target type, 282
hints for aggregation design, 464
HOLAP (Hybrid OLAP) storage mode
Analysis Services support for, 437
overview, 16
partitions and, 312-313, 431
performance and, 438, 447
HTML actions, 281
HTTP (Hypertext Transfer Protocol) connectivity, 15, 414-415
hyphen or minus sign (−)
as arithmetic operator, 79
for MDX comments, 79
as set operator, 79
as unary operator, 218, 219