Select elements in an embedded worksheet

In an embedded worksheet, for the selected axis, click an element on the pivot row or column to display the aggregate element and the children.

Use the expand and collapse options to view the child elements. To reset the dimension for the elements to the default worksheet selections and layout, you must update (refresh) the worksheet. This update is based on the configuration and module data context. You can also use the expand option for the pivot attributes, if defined.

Note: 
  • When you modify the worksheet data and expand the elements on the pivot (to display the child elements), the application discards the changes that are not yet recalculated.
  • The dimensions of the measure is a flat structure and therefore does not support the drill down to the data. The Expand option for the elements is also not applicable.

If the elements in a dimension contain aggregate and child elements, the aggregate elements are displayed in bold.