If you are on 7.0.6 HF# 02 or 7.0.7 then please reach out to TDV support team for help and they will assist you get it resolved. If you are on 7.0.8 version then please try the below suggested workaround/solution:

1. Generate execution plan for SAP Hana related to queries/views from recently upgraded environment and older version environment.
2. Compare the execution plan from both the environment.
3. If the execution plan looks different then please change the below configuration to "true":

“Studio > Administration > Configuration > Data Sources > Sap Hana > Keep all columns” --- set this to "true" (default is false)

4. Now repeat the step#1 and step#2. Now if execution plan looks same then performance issue should be resolved.

5. Now try to execute the query in upgraded environment and verify the performance.

Note: The above mentioned configuration was implemented in 7.0.8 version.

Experiencing Performance Issue for SAP Hana Queries After Upgrading to 7.0.6 HF#02 (or 7.0.7 or 7.0.8)