Advanced form settings provide users with a deeper level of customizability. You can access these settings by going to the General tab of the Form Editor and selecting Settings .
Note: All descriptions below refer to when the user has enabled the setting.
|Row aggregate indicator
|Displays an entire row when containing a non-leaf member on the row axis, in user-selected color
|Input cell and annotation indicator
|Displays available input/annotation cells in user-selected color.
|Displays all drop-down cells that are available for input with the selected color.
|Alternate row color
|All even rows use the first color option, and odd rows use the second color option.
|Increase and decrease color
|On refresh, highlights numbers that increase in first color option and numbers that decrease in the second highlighted color.
|Show grids on row
|Displays gridlines on the row axis region.
|Show grids on column
|Displays gridlines on the column axis region.
|Show grids on data
|When checked, displays gridlines in the data region of the Form.
|Show grids on corner
|Displays gridlines in the corner of the Form between the row and column axis.
|Displays a border around the edge of the Form.
|Red for negative numbers
|Colors negative values in red.
|Bold parent members on row
|Similar to the row aggregate indicator, but displays data in bold.
|Hide spreadsheet headers
|Hides all spreadsheet headers.
|Auto merge rows
|Automatically merges row axis members with the same value to Form continuous cells, when possible.
|Auto merge columns
Automatically merges column axis members with the same value to Form continuous cells, when possible.
|Enable expand and collapse
|Allows hierarchy members along row and column axes to be expanded and collapsed. Click here for more information.
|Preserve user expanded and collapsed rows
|Expanded or collapsed hierarchy members along the rows won't reset upon refresh. Click here for more information.
|Preserve user expanded and collapsed columns
|Expanded or collapsed hierarchy members along the columns won't reset when the Form is refreshed. Click here for more information.
|Translates formulas from spreadsheet coordinate space into MDX tuples.
|Query includes annotation and text cells
|Enables annotations on the Form. For large Forms, it is advised to have this property unchecked for performance considerations.
|Data changes detected within a Dashboard App triggers an automatic refresh.
|Override SSAS format
|Formatting applied on the Form overrides any formatting applied by SSAS.
|Discard user formula
|Submissions automatically discard user-entered formulas upon saving. This feature is useful when managing multiple users who are inputting on the same slice of data, as it prevents formulas from being inconsistent between users.
|Automatically adjusts the height of rows to fit the content in the largest cell.