Insert a hierarchy

You can use a dynamic expression to insert a hierarchy in an Exploration View based on the structure of the metadata tree.

You do this by selecting an insert member option that creates a dynamic expression, such as the Insert Member With Children option, and then dragging a node item to either the rows or columns drop zone.

Alternate hierarchies of the same dimension can only be stacked in the same Exploration View. They cannot be nested or used on opposite axes. Alternate hierarchies of the same dimension, for example, Retailers by Geography and Retailers by Type, do not produce logical results when combined on the same Exploration View as nested items or on opposite dimensions. To combine two alternate views of the same hierarchy, you must model them as separate dimensions. If they are available as separate dimensions, they can be combined on the same Exploration View. For example, it would be possible to place Retailers by Type on rows with Retailers by Geography on columns, and Retailers by Type on rows with Retailers by Geography nested on rows.

Procedure

  1. In the task pane, click insert member button and select Insert member with children .
  2. In the source tree, drag the hierarchy that you want to insert to the Rows or Columns drop zone.

Results

Note: If by using one of the multiple selection techniques, you dragged an item and one of its children to Rows or Columns, you may notice that it appears twice. If this was accidental, you can delete the repeated item. To remove an item, in the work area, right-click the item and then click Delete.

The items appear in the Exploration View in their expanded format.