UNPIVOT data is a common requirement especially when we try to covert MS SQL query into SAP HANA data model. I ran into one such requirement, we had ETL data from MS SQL server to SAP HANA Enterprise and while converting one MS SQL model into HANA model I came across a Select query in MS SQL server where they were using UNPIVOT in Select statement.
I am using a simple example to explain how we can UNPIVOT data in HANA using Graphical Calculation View.
I am using a simple example to explain how we can UNPIVOT data in HANA using Graphical Calculation View.
