Expand and Explode
The Discover tools allow you to Expand a Tree Node to display all of its child nodes and/or leaves or Explode a selection, duplicating the current Excel sheet for each of its child nodes and/or leaves.
Expand
Expanding a selection will insert rows below the selection and display the ChartField values (leaves) or the tree nodes and ChartField values (full hierarchy or just one level) depending on which expand option you select. The available options are:
- Expand Tree
- Expand Tree Hierarchy
- Expand Tree Hierarchy one level
Explode
Exploding a selection will duplicate the current Excel sheet for the ChartField values (leaves) or the tree nodes (full hierarchy or just one level) depending on which explode option you select. The available options are:
- Explode Tree
- Explode Tree Hierarchy
- Explode Tree Hierarchy one level