Setting Data Validation Properties

You can set application properties for data validation rules in the application. With MAX_VALIDATION_RECORDS, you can specify the maximum number of validation failure entries to display in the Data Validation Messages pane that displays in forms. When the number of errors exceeds this limit, the entries for lower-priority rules are removed. Higher-priority errors remain, such as rules set to Do Not Promote. With VALIDATION_CACHE_SIZE, you can specify the maximum number of data validation rules that are cached to improve performance. For information on creating data validation rules, see Managing Data Validation.

To set data validation properties:

1. Select Administration, then Application, and then Properties.
2. Select Application Properties to set properties and values for a Oracle Hyperion Planning application.
3. Add the property by clicking Add, entering the property in the blank row, and entering a value in Property Value:

   • MAX_VALIDATION_RECORDS: The maximum number of records to display in the Data Validation Messages pane. The default setting is 100.

   • VALIDATION_CACHE_SIZE: The maximum number of data validation rules that can be cached. The default setting is 10,000.

4. Click Save and confirm your changes.