...

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 the number of differences found for each record type in a summary table along with a visual representation of the table. A detail table lists each record where differences were found and shows the actual amounts in the source and SQL pool tables 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.

Filters

FiscalYear

Fiscal year of the financial transaction

...

Another column shows the calculated difference between the two amounts. Overall totals are shown at the bottom for each amount.

Query Pairs

Shows the actual source and target SQL queries for each record type is used to retrieve the amounts for comparison.

Data Refresh Schedule

Data in this report is updated daily (expect on Sundays) and is included in the same schedule/pipeline as the rest of the data for Financial Analytics.

...