How to do Reconciliation between BI and ECC data

hi experts,

we have requirement to do the reconciliation between BI Report data and Source data for some reports based on some parameters. Currently we are doing this mannualy.

please suggest how to autiomate this process so we can save time.