1. Working with Oracle Smart View for Office (Mac and Browser)
  2. Ad Hoc Analysis
  3. Zooming In and Out
  4. Zooming In

Zooming In

You can zoom in on members in the grid to display data for their children and descendants.

To zoom in on a member:

  1. Select a member in the grid.
  2. From the provider ad hoc ribbon, click the down arrow next to Zoom In.

  3. From the Zoom In option, select the required option:

    • Next Level to retrieve data for the children of the selected members
    • All Levels to retrieve data for all descendants of the selected members
    • Bottom Level to retrieve data for the lowest level of members in a dimension

Note:

  • When you zoom in on a page dimension, the page dimension is pivoted to a row dimension.
  • You cannot zoom in on member formula cells when connected to an aggregate storage database.

  • In Native mode, any blank rows inserted in to an ad hoc grid will be removed when a Zoom In is performed.

    Native mode refers to the Smart View Ad Hoc Behavior setting for the application. Administrators set this option in the EPM Cloud web. When the application you're connected to is running in Native mode, then the Smart View Ad Hoc Behavior option is set to Native.