Preferences for Ad Hoc Options
In the Ad Hoc Options tab, set the display preferences and behavior of ad hoc grids.
From the Home page, go to Tools > User Preferences and click the Ad Hoc Options tab. On this tab, you can set the preferences described in the following table. After you finish setting your preferences, click Save.
Field Name |
Function |
---|---|
Member Inclusion |
You can check one or both of the following options:
|
Zoom in |
Choose the level at which to zoom in:
|
Ancestor Position |
Choose how to display ancestors in the hierarchy:
|
Display Member Label as |
Select whether member names, aliases, or both appear:
|
Alias Table |
Select one of the following alias tables to use:
|
Indentation |
Choose how member hierarchy levels are indented:
|
Navigate without refreshing data |
Check to improve performance as you move around the grid, for example, when you pivot and zoom. Click Refresh when you want to update the data. If you do not select this option, data refreshes as you work in ad hoc. |
Suppression |
|
Zeros |
To hide rows or columns with zeros, check one or both of the following options:
|
Suppress |
Check one or both of the following elements to hide from the grid:
|
Missing data |
To hide rows or columns with zeros or that have no data, check one or both of the following options:
|
No Access |
To hide rows or columns that you have no access to, check one or both of the following options:
|
Precision |
|
Use currency member setting |
Check to apply the precision setting to the Currency member. If you check this option, you cannot set minimum and maximum values for currencies. |
Currency Values |
Set the minimum and maximum number of decimal positions to show in a cell for currency values from the Minimum and Maximum list. |
Non-Currency Values |
Set the minimum and maximum number of decimal positions to show in a cell for non-currency values from the Minimum and Maximum list. |
Percentage Values |
Set the minimum and maximum number of decimal positions to show in a cell for percentage values from the Minimum and Maximum list. |
Replacement |
|
No Data |
Enter the text to show for cells that have #Missing or #NoData as their value. |
No Access |
Enter the text to show for cells that you do not have access permission to view. |
Submit Zeros |
Check if you specified #NumericZero as the text for the No Data or No Access replacement option and you want to submit zeros. |