Member Options

To set options for the display of member cells as described inTable 7, click Options on the Smart View ribbon, and then select Member Options in the left panel.

Table 7. Member Options

Option
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 display only the next level down in the hierarchy of members All levels to display all levels in the hierarchy Bottom level to display only members in the lowest level of the hierarchy
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 fully qualified names Member Name and Description to display fully qualified names and descriptions (aliases) Description Only to display aliases. In free-form mode, fully qualified names are displayed until after you manually add, remove, or edit any comments and refresh.
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
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.
Mode
Use Double click for Operations	Double-clicking retrieves the default grid in a blank worksheet and thereafter zooms in or out on the cell contents. Otherwise, double-clicking retains standard Excel functionality and puts a cell into edit mode. If Oracle Essbase Spreadsheet Add-in and Smart View are installed on the same computer and you have not completed the steps in Smart View and Spreadsheet Add-in, double-clicking prompts you to log into Spreadsheet Add-in.
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 make changes to the POV. Otherwise, any formulas in the grid are lost.