Data options are the Anaplan XL installation level defaults, which are applied to any new workbooks opened during the Excel session.
General data options
Set how long before the Cancel Query button appears, the default connection time-out, and where to save Dynamic Charts files.
The general data options include:
Member options
Select how members are shown, filtered, searched, and expanded.
The member options include:
| Member options | Description |
| Default at level view in member tree | Sets the default view of hierarchies to be level-based, rather than member-based. |
| Limit for quick search | Limits the number of members that can be searched for to the specified value. If there are more items available in the Member Selector tree view, the Advanced Member Searching dialog is displayed instead. |
| Default search type | Select a default search type to use for a quick search:
|
| Limit number of members returned in tree to | Limits the number of members returned in the Member Selector tree view to the specified value. Review Expand Large Hierarchies for more information. |
| Auto-expand levels in Compact Grids | When the compact style is used for a grid, the first level is automatically displayed; otherwise, only the total is shown. |
Measure options
Configure how to sort, display, and create a measure.
The measure options include:
| Measure options | Description |
| Sort measures alphabetically | Sorts the measures alphabetically, instead of 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. |
| Use Implicit measures in Power BI / Tabular SSAS | Creates a measure by applying a standard aggregation function, such as SUM or COUNT, to the field that's been dragged to the Selected Columns area of the Table Editor. |
Hierarchy options
Choose how hierarchies are sorted, displayed, and selected.
The hierarchy options include:
| Hierarchy options | Descriptions |
| Sort hierarchies alphabetically | Sorts hierarchies alphabetically, instead of 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 the hierarchy editor | Adds named sets defined in the cube or in the workbook in the hierarchy editor alongside normal members. |
| 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. |
| Pick parent-child hierarchies by default | Select the first parent-child hierarchy in the list of hierarchies in the Report Designer, instead of the first field. |
Writeback option
Choose the maximum number of cells that can be written at once.
The writeback option includes:
| Writeback option | Description |
| Maximum cells to writeback in one edit | Maximum number of cells that can be written at once. Use to optimize write processing when the performance of the source model or connection is limited. |
Formula engine options
Set how formulas update and control the MDX used in formula reports.
The formula engine options include:
Tabular Analysis Services options
Set whether Anaplan XL automatically attempts to disable unrelated columns for the Tabular Report Designer.
The Tabular Analysis Services options include:
Pivot view options
Choose the maximum rows and cells to retrieve an the CSV text driver.
The pivot view options include:
Power BI options
Select the Power BI Protocal to use.
The Power BI options include:
| Power BI options | Description |
| Power BI Protocol | Protocol to use for Power BI connections. |
Essbase options
Select to use the Anaplan XL XMLA provider to connect to Essbase and how Essbase retrieves the caption type.
The Essbase options include:
SAP options
Manage options SAP Hana and BW protocol settings, set the log path, and choose how connection pools open and close during refresh.
The SAP options include:
Kyvos option
Set the connection to Kyvos.
The Kyvos option includes:
| Kyvos option | Description |
| Kyvos Protocol | Communication protocol to use when connecting to Kyvos. |
Teradata option
Set the connection to Teradata.
The Teradata option includes:
| Teradata | Description |
| Teradata Protocol | Communication protocol to use when connecting to Teradata. |
TM1 options
Control how TM1 connects, verifies the server, registers functions, converts workbooks, searches metadata, and displays cube text.
The TM1 options include:
Anaplan options
Choose the Anaplan environment, sign in through the Anaplan web authentication page, and set the maximum cell request size.
The Anaplan options include:
| Anaplan option | Description |
| Environment | Default environment to use when connecting to Anaplan. |
| Use Universal Login | Use Anaplan web authentication page. |
| Maximum cellset request size | The maximum number of cells that can be returned when querying Anaplan. |
Incorta option
Add the authentication URL to connect to Incorta.
The Incorta option includes:
| Incorta option | Description |
| OAutho info url | Authentication URL to use for connecting to Incorta. |
Relational data option
Select how to load metadata in the Report Designer. The relational data option includes:
| Relational data option | Description |
| Load metadata in the designer by default | Uncheck this option to prevent the list of available objects in the Query Editor from loading automatically. Use the Display Metadata button to load the metadata on demand in the same window. |
