Selecting Members to Display when Zooming

You can set options to specify which members are retained and displayed as you zoom in and out.

To set member display options for zooming:

  1. From the Oracle Smart View for Office ribbon, select Options, and then select Member Options in the left panel.
  2. Under Member Retention, select:
    • Include Selection to display both the selected member and the members retrieved as a result of zooming. For example, zooming in on the selected member Qtr1 retrieves data for Jan, Feb, Mar, and Qtr1. If not selected, only the members retrieved as a result of the zoom are displayed: Jan, Feb, and Mar.

    • Within Selected Group to zoom in only on the selected group of cells, leaving the unselected cells as is. This setting is meaningful only when there are two or more dimensions down the grid as rows or across the grid as columns. (This setting also applies to Keep Only and Remove Only.)

    • Remove Unselected Groups to remove all dimensions and members except the selected member and the members retrieved as a result of zooming.

  3. Click OK.