...
The Financial Analytics - Auto Validation report will be used to identify discrepancies in amounts found between the source and the Azure SQL pool tables for finance. The report shows a bar chart with the total number of differences found for each record type in a summary table along with a visual representation of the tablespecified validation date range. A detail table lists each record where differences were found and shows the actual identified with the amounts in the source and SQL pool tables shown along with a column that shows the difference between the two amounts. The report also shows the actual SQL queries used to pull the amounts for each record type.
...
The validation date range of records to show(defaults to the last 2 weeks)
Visualization
Actuals RecordDiffCount
Shows the total number of records where differences in amounts were found for a found to have different amounts for the specified record type (Actuals) on a specific and validation date. By default, the number shown is from the most recent run.
Encumb RecordDiffCount
Shows the total number of records where differences in amounts were found for a found to have different amounts for the specified record type (Encumbrance) on a specific and validation date. By default, the number shown is from the most recent run.
Budget RecordDiffCount
Shows the total number of records where differences in amounts were found for a found to have different amounts for the specified record type (Budget) on a specific and validation date. By default, the number shown is from the most recent run.
Req RecordDiffCount
Shows the total number of records where differences in amounts were found for a found to have different amounts for the specified record type (Requisition) on a specific and validation date. By default, the number shown is from the most recent run.
RecordDiffCount by ValidationDateTime(bins) and ValidationType
Bar chart that displays shows the number of records having different amounts for each record type over a specified period of time.
Details
Validation Detail
Shows the amounts pulled for each record. The source table and SQL pool amounts are shown for each record type, validation date, fiscal year, accounting period, business unit, account, operating unit, fund code, department, initiative, project, and product.
Another column shows the calculated difference between the two amounts. Overall totals are shown at the bottom for of each amount column.
Query Pairs
Shows the each record type’s actual source and target SQL queries for each record type is that were used to retrieve the amounts for comparison.
...