Ad Hoc Options

You can set preferences to control the display and behavior of ad hoc grids. See Using Ad Hoc for Data Entry and Analysis for more information on ad hoc grids.

Table -7 Ad Hoc Options

Preference	Description
Ad Hoc Options
Member Inclusion	How members are displayed. Include selection: Displays both the selected member and the members retrieved as a result of the operation. For example, zooming in on the selected member Qtr1 displays data for Qtr1, Jan, Feb, Mar. Within selected group: Performs an operation such as Zoom only on the selected group of members, 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. This option pertains to Zoom, Keep Only, and Remove Only.
Zoom In	Level at which to zoom in: Next level: Retrieve data for the children of the selected members. All levels: Retrieve data for all descendants of the selected members. Bottom level: Retrieve data for the lowest level of members in a dimension.
Ancestor Position	How to display ancestors in the hierarchy: Top: Display member hierarchies in order from highest to lowest level. Bottom: Display member hierarchies in order from lowest to highest level.
Display Member Label As	Whether member names, aliases, or both are displayed.
Alias Table	Which alias table to use. An alias is another, often more descriptive, name for a member. Sets of aliases are stored in alias tables. For example, you may have an alias table for English member names, another alias table for German member names.
Indentation	How member hierarchy levels are indented: None: No indentation. Subitem: Indent descendants. Ancestors are left-justified in the column. Totals: Indent ancestors. Descendants are left-justified in the column.
Navigate without refreshing data	Selecting this option improves performance as you navigate around the grid, for example pivoting and zooming. Click Refresh to update the data. If you don't select this option, data is refreshed as you work in ad hoc.
Suppression
Zeros	Row: Select to hide rows containing only zeros. Column: Select to hide columns containing only zeros.
Suppress	Repeat members: Select to hide rows that contain repeated member names, regardless of the grid orientation. Missing blocks on rows: Select to hide blocks of cells in rows that have no data.
Missing Data	Select to hide rows or columns with zeros or that have no data.
No Access	Select to hide rows or columns that you don't have access to. Note: If you get an error when you try open an ad hoc grid that says "Ad hoc grid cannot be opened as there are no valid rows of data", then clear the above Suppression options.
Precision
Use Currency Member Setting	Select to apply the precision setting of the Currency member. Set the minimum and maximum number of decimal positions to display in a cell for Currency Values, Non-Currency Values, and Percentage Values. For example, if the cell value is 100, and you set the Minimum precision to "2", then the value displays as "100.00"
Replacement
No Data	Text to display for cells that have #Missing or #NoData as their value.
No Access	Text to display for cells that you don't have access permission to view.
Submit Zeros	Select if you specified #NumericZero as the text for the No Data or No Access replacement option, and you want to submit zeros.