Options are the Anaplan XL installation level defaults, which are applied to any new workbooks opened during the Excel session.
User interaction
The types of various user interactions include:
| Interaction Type | Description |
| Language | Select to set interface language. |
| Show right-click menu option at top (restart Excel to apply) | The Anaplan XL right-click menu option is by default at the bottom. |
| Use task pane for new grids | Automatically opens task pane when a new grid is created. |
| Automatically apply changes in task pane | Changes are made instantaneously. |
| Disable draggable grid labels | Force all dimension labels on Grids to be hidden. |
| Case sensitivity | Selects whether searches should be case-sensitive, case-insensitive, or should use the cube default. |
| Automatically select Children of first member | The children of the first member are applied as members when a hierarchy is selected, for example, for a slicer.) |
| Don't show Small Multiples warning | Controls whether Anaplan XL warns when it limits the number of charts it shows in a Small Multiple chart. |
| Display Conversion Options | Shows the Convert from options in the Anaplan XL ribbon. |
| Use default credentials for web proxy | Apply Windows' standard proxy settings when connecting to web services. |
| Use Google China for maps | Whether to use Google China for maps. |
Data options
The types of various data options include:
| Data Options | Description |
| Show Cancel Query button after | Time before long queries are canceled (in seconds). |
| Default at level view in member tree | Sets the default view of hierarchies to be level-based, rather than member-based. |
| Use single members on filters | Implements select and replace on hierarchies in the filter area of grids (selecting a member replaces any existing selected member). |
| Limit for quick search | Limits the number of members to search for to the value specified in the user interface. |
| Limit number of members returned in tree to: limits to specified value in user interface. See Expanding Large Hierarchies for more information. | |
| Sort measures alphabetically | Rather than the cube-defined order. |
| Show measures groups | Where applicable, show Measures in their Measure Groups as defined in the cube. |
| Default at level view in measure tree | Sets the default view of the measures hierarchy to be level-based, rather than member-based. |
| Sort hierarchies alphabetically | Rather than the cube-defined order. |
| Show dimensions in folders | Display folders shown at a level above the dimension rather than beneath the dimension. |
| Show named sets in hierarchy editor | Adds named sets defined in the cube or in the workbook in the hierarchy editor alongside normal members. |
| Show slicers in hierarchy editor | |
| Display Dimension Name with Hierarchy Name | Prefixes the hierarchy name with the dimension name. |
| Show sets in folders | Controls whether Anaplan XL displays named sets in defined display folders or not. |
| Formulas move With Members to Where clause | Controls the MDX generated for formula reports. |
| Formulas maximum Tuple count | Controls the MDX generated for formula reports. |
| Disable Tabular columns in Designer | Sets whether Anaplan XL automatically attempts to disable unrelated columns for the tabular report designer. |
| Pivot View maximum rows to retrieve | The maximum number of rows to include in the report (default 100,000). |
| Pivot View maximum cells in report | The maximum number of cells to include in the report (default 10,000,000). |
| Essbase Caption Type | Selects from where the Essbase connection retrieves its captions. |
| SAPHanaProtocol | The connection protocol used, for example, OLEDB, ADO.NET. |
| SAPBWProtocol | The connection protocol used, for example, OLEDB, ADO.NET. |
| SAPHanaLogPath | The log path for SAPHana connections. |
Web publication
Various Web publication options include:
| Web publication | Description |
| Maximum number of columns allowed | The maximum number of columns allowed per page. |
| Maximum number of rows allowed | The maximum number of rows allowed per page. |
| Default Web Address | The default web address for publishing. Below is a list recent web servers that have been connected to. |
| Web service send timeout (minutes) | The send timeout for the publication web service. |
| Log Publication Process | If there is a problem, log additional detail. |
Workbook defaults
Controls the defaults for new workbooks.
| Workbook Defaults Option | Description |
| Format File | The default FormatSheet location. |
| Hide format sheet | Sets whether the format worksheet is hidden when created in new workbooks. |
| Default grid title | The default title of the grid. |
| Default comments web server | The default web server for commentary. |
| Available Actions – Ignore multiple filter members | If multiple members are selected on filters, these are ignored when deciding which actions to display. |
| Replace null values | Replaces null values with the contents of the Replace null values with text field. |
| Validate members | When parsing a member, the formula will check that a valid member has been selected. |
| Remove drill indicators | Don't display a sign showing that row/column can be drilled. |
| Remove nulls when drilling | If there are any null rows/columns when drilling down on a member, they'll be removed so that there are no fully empty rows/columns in the report. |
| Remove 0 values when drilling | If there are any rows/columns when drilling down on a member that only contain zeros, they'll be removed so that there are no zero rows/columns in the report. |
| Resize Columns after drilling | This allows a column to resize itself when drilled. |
| Indent drilled members | When the user drills down on a member, they'll be displayed indented. |
| Lighten background color on drill | When the user drills on a member, a slightly lighter version of its background color will be used for the new members. |
