Modeled Sheet Data Validations

We add a new Data validations in Sheets check box on the Visual Preferences page of Administration, enabling you to:

Create data validation rules for modeled sheets in Model Management.
Use data validations on modeled sheets.

We also add a new Data validations in Import Data (requires Data validations in Sheets) check box, enabling you to enforce or skip data validations when you use the Import Data page in Integration.

See Change Visual Preferences.

When you edit a sheet on these Model Management pages, we add a new Data Validation Rules page:

Level Assigned Sheets
User Assigned Sheets

We only display the new page for modeled sheets that weren't created by a planning configuration manager.

You can now create data validation rules for each sheet. For each rule, you can configure:

The active or inactive status of the rule.
The validation expression manually or using an expression builder.
The validation help text to display to your sheets users when they enter invalid data.
Whether the rule rejects invalid data or allows invalid data with a warning.

See Set Up Modeled Sheet Data Validation Rules.

When you enter data on modeled sheets that violate an active data validation rule, we now display your configured validation help text and either an:

Orange border around the row in error for soft errors. You can still save the sheet while this invalid data exists.
Red border around the row in error for critical errors. You can't save the sheet while this invalid data exists.

See Reference: Colors and Notations in Sheets.

When you import modeled sheet data with the importConfigurableModelData API, we provide a new importDataOptions element with a Boolean applyValidationRules attribute. Setting this attribute to true performs modeled sheet rule validation on your import.

Note: The importDataOptions element and applyValidationRules attribute are only available in API v37 and above.

See importConfigurableModelData.