Member Options

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

To set options for the display of member cells as described in Table 13, 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.

Note:

Not all data providers support all the options listed in the table.

Table 13. 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 Name Only to display member names 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	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. 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.