Validate Data

Special validation rules can be defined for each model which are then used to test actual period submissions before allowing the period to be closed and locked.
There is no limit to what can be validated, the only criteria is that the rule must evaluate to zero for valid data.

The validation rules are created as part of the initial model design and typically would include a check to make sure the balance sheet is balanced and perhaps that certain data sub analyses aggregate back to match the known total for that item. See Rules

To Validate data, click on the Validate button in the ribbon.
Choose the entities and version to be checked
Click OK

If there are no validation errors, a Process Completed Message will be displayed.

If, however, some of the data does not pass validation a message will be displayed telling you which entity, version, time period and product combination failed and on which validation rule. Click Yes to continue and move onto the next check, click Yes All to continue without displaying any further individual validation errors, or click No to stop the validation process.

Validation error for a particular entity.

You can then use a browser to display the validation accounts and to make any necessary data adjustments to resolve the differences.

!If you choose Yes All to continue through the validation checks without displaying any further messages, the details of all the validation errors can be found listed in a log file in the Cubix model ‘database’ folder. This will usually be similar to the following:

\Cubix\Models\model_name\database\sessionuserid.log

Where model_name is the name of the current model and userid is the user name of the user running the validation process.

!If an entity has failed validation, the Roll CAP or Roll Period Blocks processes cannot be run for that entity.