One of the user running WebI report created on Universe which is on HANA CV and during one of the testing process , we found out that number of rows between CRM query(SQL Query) (Which is source) is less when compared with HANA view.
I did checked the Staged table in HANA and it is also giving me matching results when compared with the source but not Analytical view or Calc view.
Just a filer was applied at ETL side on table but nothing at view side.
Little confused and lost why the result set has the discrepancy.
Any thoughts or advices are appreciated.