Zooming In

You can zoom in on one cell at a time. In Oracle Essbase, Oracle Analytics Cloud - Essbase, and Oracle Enterprise Performance Reporting Cloud, you can also zoom in on a range of cells.

Zooming in to the Default Level

To zoom in to the default zoom level, which is specified as described in Setting a Default Zoom Level, do one of the following:

  • Select a member, and then click Zoom In on the data source ribbon. In Essbase, Oracle Analytics Cloud - Essbase, and Oracle Enterprise Performance Reporting Cloud, you can select a range of members.

  • Double-click a member (double-click zooming must be enabled; see Enabling Double-Click Zooming).

Zooming in on Shared Members in Oracle Planning and Budgeting Cloud and Oracle Enterprise Planning and Budgeting Cloud

For 16.12 and earlier, Planning did not support shared members. When a member was placed on an ad hoc grid, it was always considered a base member, even if it was supposed to be a shared member.

Starting in 17.01, Planning supports shared members in ad hoc grids and recognizes whether a member is a base member or a shared member. Starting in 17.04, if your administrator enables zoom in on shared members in your application, then zooming in on shared members is supported in Oracle Smart View for Office. In this case, zooming in on shared members is effectively the same as zooming in on the corresponding base members.

Zooming in to a Selected Level

To zoom in to a selected level:

  1. Select a member.

    In Essbase, Oracle Analytics Cloud - Essbase, and Oracle Enterprise Performance Reporting Cloud, you can select a range of members.

  2. From the data source ribbon, click the down arrow next to Zoom In, and then select one of the following options.

    • 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

    These Zoom In options are available for Essbase and Oracle Analytics Cloud - Essbase only:

    • Same Level to retrieve data for all members at the same level as the selected member

    • Sibling Level to retrieve data for the siblings of the selected members

    • Same Generation to retrieve data for all members of the same generation as the selected members

    • Formulas to retrieve data for all members that are defined by the formula of the selected member. The formula can be a member equation or a consolidation to the parent

    Note:

    When you zoom in on a page dimension, the page dimension is pivoted to a row dimension.

    Related Topics: