Is Pivot available in SAP HANA

SAPSAP HANA

As per my understanding, for requirement #1 you can do something as below:

SELECT    Prod.Product_ID, JOB.Job_ID, SUM(J.Time)
FROM    TABLE_1 Prod
 INNER JOIN TABLE_2 Job ON Prod.Job_Id = Job.Job_ID
GROUP BY     Prod.Product_ID, Job.Job_ID

SAP HANA does not support Pivot built-in as done by SQL but majorly it looks as a UI requirement. So what you can do is send the entire result to report and apply transformation in the report as per your requirement.

raja
Published on 25-Dec-2017 13:24:38
Advertisements