Skip to Content
0
Jun 23, 2016 at 02:12 PM

Number of Rows difference between CRM query and HANA view

84 Views

Hi,

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.

Thanks,

Jothi