Member Options

Member options are sheet level options, which are specific to the worksheet for which they are set.

Note:

Not all data providers support all the options listed in Table 20-1. Refer to the Subtopics listed above to find the options supported for a particular provider.

To set options for the display of member cells as described in Table 20-1, click Options on the Smart View ribbon, and then select Member Options in the left panel. When you are finished, make a selection for saving the changes:

  • OK

  • Save as Default Options

  • Apply to All Worksheets

    Note:

    The Apply to All Worksheets option is not available in PowerPoint or Word.

See Sheet Options for a complete description of the above options.

Table 20-1 Member Options

Option Description
General General
Zoom In Level From the drop-down menu, select one of the following to specify a default zoom level for ad hoc analysis:

  • 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

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

  • Same 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.
Member Name Display From the drop-down menu, select one of the following to specify how to display member names in cells:

  • Member or Alias Name to display member names only or, if an alias table is being used, alias names only.

    Oracle Essbase and Oracle Enterprise Performance Reporting Cloud: Note that this is the default when connected to duplicate member databases and launching an ad hoc grid or, for Essbase only, Query Designer. This is the default even if you have chosen the Distinct Member Name option and set it as the default.

  • Distinct Member Name to display fully qualified names

  • Member Name and Alias to display member names and their aliases

  • Description Only to display aliases
Indentation From the drop-down menu, select one of the following to specify how hierarchy levels are to be indented:

  • None

  • Subitems to indent descendants. Ancestors are left-justified in the column.

  • Totals to indent ancestors. Descendants are left-justified in the column.
Ancestor Position From the drop-down menu, select one of the following to specify ancestor position in hierarchies:

  • Top to display hierarchies in order from highest to lowest level

  • Bottom to display hierarchies in order from lowest to highest level

Note:

Essbase does not support the Ancestor Position options.
Member Retention Member Retention
Include Selection Display the selected member and the members retrieved as a result of the operation.
Within Selected Group Perform ad hoc operations only on the selected group of cells, leaving 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. For Zoom, Keep Only, and Remove Only.
Remove Unselected Groups For Zoom In or Zoom Out, remove all dimensions and members except the selected member and the members retrieved as a result of zooming.
Comments and Formulas Comments and Formulas
Preserve Formulas and Comments in ad hoc operations (except pivot and undo) Preserves formulas and comments on the grid during queries. You can clear this option to make queries run faster, but if you do, formulas and comments are removed or ignored.

Note that formulas are not preserved for pivot or undo operations, regardless of whether or not this option is selected.

This option must be selected if you select Formula Fill or Enable Enhanced Comment Handling.

Note:

This option applies to formulas in both member and data cells.
Formula Fill Propagates formulas associated with member cells to the members retrieved as a result of zooming in.

If Preserve Formulas and Comments in ad hoc operations except pivot and Use Excel Formatting are both selected, propagates cell formatting to the members retrieved as a result of zooming in.

Note:

This option applies to formulas in both member and data cells.
Enable Enhanced Comment Handling Enables you to review and correct comments and member names in ad hoc grids that contain comments.
Preserve Formula in POV Change Preserves formulas in cells when you refresh or make changes to the POV. Otherwise, any formulas in the grid are lost.

The sections that follow list the Member Options supported by provider.