The Pivot Trees component uses the OnCellDoubleClick event that an embedded pivot exposes to expand or drill into hierarchies of information. The operation is similar to using Tree Views in the Tree component (see Dashboard Studio Tree Component).
The component initially displays top level nodes in pivots. However, when a row containing Pivot Trees properties is double-clicked, the descendants are displayed or hidden.
Note:
The Pivot Trees component uses appended queries to view data in a hierarchical structure. An appended query is a group of different queries appended together. Each query in an appended query has the same column names and column data types. For detailed information on appended queries, see the section titled “Appending Queries” in the Hyperion Interactive Reporting Users' Guide.