5.1 Validating Reports
DPM Authority can review a completed report by evaluating the list of validation rules incorporated in the XBRL taxonomy. These validation rules will mirror those which will be performed at the respective regulator’s submission gateway.
Validating Reports
Select the Validate Report button in the Processing ribbon to run validations on the entire report:
Inconsistent duplicate fact errors
In a data point model, an individual fact may appear on more than one table. In an XBRL instance, it is not possible to determine from which table a duplicate fact originates since duplicate facts contain the exact same XBRL tag. Duplicate facts are only inserted into the XBRL instance once regardless of how many times they appear across the set of tables being submitted. (See Duplicate Facts for more information).
We recommend first resolving duplicate fact errors before trying to resolve any validation failures as some duplicate fact errors can result in validation failures that would have passed if the all duplicate facts were consistent.
If any exist, these will be displayed above the taxonomy rule validation results:
The results are pre-grouped to display each set. clicking on any of the hyperlinks will take you to the cell that contains the fact. Since a fact can only be inserted into the XBRL once, the "Value If Not Resolved" column indicates which value will be used if the inconsistency is not resolved.
Automatic Resolving of Inconsistencies
A new "Resolve" column has been added to the table. This allows you to automatically resolve any inconsistencies. If you place a checkmark next to a single fact in each set and press the "Resolve Set" button in the toolbar. The software will automatically adjust the value of all facts with the set to agree to the value of the fact that you have placed the checkmark in. Please however note:
- If you re-import your source data which contains the inconsistency the inconsistency will re-appear.
- If one of the facts in the set is a calculated data object, indicated by the "...(Calculated)" suffix, after resolving the inconsistency the software will perform a re-calculation which could re-introduce the inconsistency.
Taxonomy Validation Rules
Any taxonomy validation rules will appear in a pre-grouped table. The table will appear below any inconsistent duplicate fact errors (if they exist).
Columns
There are 7 columns in the table:
- Severity
- Code
- Taxonomy Label
- Taxonomy Message
- Expression (Addresses)
- Expression (Values)
- Delta
3 & 4 are sourced directly from the taxonomy. 5 and 6 are calculated by DPM Authority.
Depending on the taxonomy, you may find that some columns contain redundant / duplicated information. To reduce the amount of redundant /duplicated information you can choose to hide columns using the Show/Hide Columns button in the toolbar:
Any columns you choose to hide will be remembered in your user settings and will remain hidden across all reporting unless you choose to once again display it using the same form.
For example, in this case from the EBA taxonomy, the column Taxonomy Message contains a duplication of information found in the "Taxonomy Label" Column:
In this case you may decide to hide the Taxonomy Label column.
However, for the Solvency II taxonomy, the "Taxonomy Label" column provides a valuable description of the rule's purpose, so you might choose to keep it visible:
Filtering
DPM Authority data grids contain powerful filtering functionality that can be used to search for specific data points across all rules. In the example below, DPM Authority will filter the validation results to all those that have failed and contain the data point “*r010*”.
Exporting of results
As with all DPM Authority data grids, you can export the results in a number of formats including Excel, csv, XML etc. Click the Export Validation Results button in the Output ribbon to choose a format and export the list of validations results.