Creating hierarchies enables you to add
drill-down functionality to your reports. A hierarchy is an arrangement of category columns
that is based on
parent-child relationships. The levels of a hierarchy are arranged with more general information
at the top and more specific information at the bottom. For example, you might create
a hierarchy of datetime columns with
Year as
the top level,
Month as the
next level, and
Day as the
bottom level.
You can also have a
geographic hierarchy. For example, you might have a hierarchy with Region as
the top level, State as the
next level, and City as the
bottom level.
You can have a maximum
of two hierarchies for a report object.
Keep the following considerations
in mind:
-
List tables, controls, and
gauges do not support hierarchies.
-
Data item auto-assignment does
not support hierarchies.
-
Crosstabs can have either a hierarchy
or categories on each row or column, but not both.
-
-
Geo bubble maps, geo coordinate maps, and geo region maps allow only geographic data
items in a hierarchy.
You can also have a
date hierarchy.