Report Description

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.

...

The financial record type

ValidationDateTime(bins)

The validation date range of records to show

Visualization

Card

...

Actuals RecordDiffCount

Shows the number of records where differences in amounts were found for a specific record type (Actuals, Budget, Encumbrance, Requisition)) on a specific validation date. By default, the number shown is from the most recent run.

Encumb RecordDiffCount

Shows the number of records where differences in amounts were found for a record type (Encumbrance) on a specific validation date. By default, the numbers number shown are is from the most recent run.

Budget RecordDiffCount

...

Shows the number of records having different amounts for each record type over time.

Details

Validation Summary

Shows the total where differences in amounts were found for a record type (Budget) on a specific validation date. By default, the number shown is from the most recent run.

Req RecordDiffCount

Shows the number of records where differences in amounts were found for each a record type and validation run date.(Requisition) on a specific validation date. By default, the number shown is from the most recent run.

RecordDiffCount by ValidationDateTime and ValidationType

Bar chart that displays the number of records having different amounts for each record type over 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.

...