Just to be clear. The connection in Tableau Desktop when extract is not displaying the data as expected, but when Tableau Desktop is connected to the live SAP Hana data source it returns expected results?
why dont you create a calculation view in hana itself and then consume it directly in tableau?
- Tableau on HANA | SAP Blogs
- Creating Tableau Report on SAP HANA Analytic View a Three Step Process | SAP Blogs
please recheck the extract(tde) i guess its not created correctly.
hope it helps.