H

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