Connection

Setting	Description
License Key	Your accoPLANNING license enabling writeback - only used for non-AppSource instances
Use on-premise API	Routes traffic to your own custom API
On-premise API Domain URL	The URL for your on-premises API
Database host	The host address for your database
Database user	The user credentials for accessing the database
Database password	The password for accessing the database
Writeback table	The table for writeback within your database
Show writeback table script	Generates and shows an SQL script for creating a writeback table based on your measures
Username column	The name of the column for username within the database
Timestamp column	The name of the column for timestamps within the database
Current user	The current user of the visual (recommended to be DAX username)
Request timeout (seconds)	Timeout limit for saving data

Settings

Setting	Description
Layout	The layout of the pivot table Compact: A typical row-column matrix Classic: A stepped layout row-column matrix Flat: A table with only column headers
Row height	The visual height of rows (in pixels)
Column width	The visual width of columns (in pixels), excludes row headers.
Force manual column width	On: Enables column width setting Off: Uses dynamic column widths
Max string length	The maximum character count of comments (incl. spaces)
Aggregation labels	On: Enables aggregation labels on totals and subtotals - "sum of..." Off: Disables aggregation labels on totals and subtotals
Column and row numbers	On: Shows indices for columns and rows Off: Hides indices for columns and rows
Comment delimiter	The symbol to act as a delimiter for comment values. Splits the single comment text value into several distinct comments
Show subtotals	Off: Displays no subtotals Rows: Displays subtotals on rows Columns: Displays subtotals on columns Both: Displays subtotals on both rows and columns
Show grand totals	Off: Displays no grand totals Rows: Adds a grand total column (aggregation for all rows) Columns: Adds a grand total row (aggregation of all columns) Both: Adds a grand total row and column
Show measure in row	On: Shows the measure in the row headers Off: Displays row headers without addition
Do not save "0" values	On: Disallows saving "0" values in number cells Off: Allows saving "0" values in number cells
Move blanks to lowest level
Exclude blanks from hierarchies	On: Hides rows
Enable drill through	On: Shows detailed overview of value cells on double-click Off: Disables detailed cell overview
Batch changes	On: Allows changing multiple cell values before saving Off: Allows changing multiple cell values before saving, enables manual saving button (top-right corner)
Auto save batch changes (only visible if batch changes enabled)	On: Adds a time limit for auto-saving pending cells Off: Disables automatic saving
Auto save batch changes interval (only visible if auto save batch changes)	The time interval for automatic saving (in seconds)
Send only keys	On: Only sends transaction keys and values to database Off: Includes metadata when saving to database incl. rows and column information
Enable hierarchy	On: Enables hierarchy on rows Off: Disables hierarchy on rows, only recommended for balanced row hierarchies
Hierarchy name (only visible if enable hierarchy on)	The display name for the hierarchy (only visual, not included in writeback)
Show hierarchy	On: Adds hierarchy title to row headers Off: Hides hierarchy title on row headers
Show toolbar	On: Shows the accoPLANNING toolbar, including buttons Off: Hides the accoPLANNING toolbar, including buttons
Show loading screen	On: Displays a loading screen while saving data Off: Does not display a loading screen while saving data
Lock cells while saving	On: Disables cell editing while a save is in progress Off: Allows writing to cells while saving

Formatting

Setting	Description
Measure choice	Choose all or specific measure(s) to apply following settings to
Separators (only for [All Measures]	Power BI default: Use the Power BI locale (language) to determine separator formatting , (decimal) / . (thousand): Use comma as decimal and period as thousand separator . (decimal) / , (thousand): Use period as decimal and comma as thousand separator
Decimal places	How many decimals to include in each cell
Aggregation	Sum: Sets total aggregations for the measure to sum Average: Sets total aggregation for the measure to average
Currency symbol	Prepends each cell value for the measure with the given currency symbol
Show blank values as	Displays blank values as the given string. Note: any value other than 0 will not be included in average aggregations.

Splashing

Setting	Description
Measure choice	Choose all or specific measure(s) to apply following settings to
Default behavior	The default behavior when inputting a splashing value Popup: Displays the splashing pop-up with splashing choices Replace: Replaces all cell values within the splash with the given value Even: Distributes the given value evenly across all cells within the splash Relative, values: Distributes the given value across all cells within the splash relative to their existing value
Enable parent level entry	On: Enables entry in parent- and subtotal cells (splash range will be all child cells of the parent) Off: Only allows splashing across writeable value cells
Enable splashing	On: Enables splashing Off: Disables splashing

Cell dropdown

Setting	Description
Measure choice	Choose all or specific measure(s) to apply following settings to
Dropdown measure	Plain text: A text string with the values to populate the dropdown menu with. Measure: A given measure to populate the dropdown menu with (must be a single string)
Enable key-value pairing	On: Splits the dropdown choices between keys (sent to database) and values (displayed in the menu) Off: Dropdown choices are the same as their submitted value
Menu item separator	The symbol delimiter to separate the dropdown measure into distinct choices
Key value separator (only visible if key-value pairing enabled)	The symbol delimiter to separate each dropdown choice between key and value

Calculations

Setting	Description
Calculations	A calculation
Dropdown measure	Plain text: A text string with the values to populate the dropdown menu with. Measure: A given measure to populate the dropdown menu with (must be a single string)
Enable key-value pairing	On: Splits the dropdown choices between keys (sent to database) and values (displayed in the menu) Off: Dropdown choices are the same as their submitted value
Menu item separator	The symbol delimiter to separate the dropdown measure into distinct choices
Key value separator (only visible if key-value pairing enabled)	The symbol delimiter to separate each dropdown choice between key and value

(DEPRECATED) Settings Documentation

accoPLANNING settings (DEPRECATED)