![sap hana studio label column sap hana studio label column](http://www.bestsaphanatraining.com/img/studio-log-mode.jpg)
![sap hana studio label column sap hana studio label column](http://teachmehana.com/wp-content/uploads/2016/07/word-image-164.png)
Create Calculation View based on direct base table in each projection node.No Analytic view will be created instead base table will be used directly.Calculated Column ( VALUE) is created in each Projection node which derives the value of a particular month in a year.Create Calculation View based on general Analytic View created above and join them together using Union with Constant Value.In this case we select 6 measures M_JAN, M_FEB, M_MAR, M_APR, M_MAY, M_JUN in addition to common attributes.1 general Analytic view will be created instead of several Analytic views in which selected attributes and measures will be selected.No need to create Calculated Column ( MONTH) in each Analytic view as this can be derived in Calculation View to improve performance.Create Calculation View based on Analytic Views created above and join them together using Union with Constant Value.Calculated Column ( VALUE) is created in each Analytic view which derives the value of a particular month in a year.In this case 6 columns need transposition, hence 6 Analytic views will be created.Analytic view will be built on each base table column which needs transposition.Special thanks to Pradeep Gupta for making this document more better than before. Special thanks to Justin Molenaur and Krishna Tangudu for making this better.īased on comment, this document was modified on May 2, 2016. Once the table is available in HANA studio, modeling will be done based on HANA base table and output of the Information view will be the transposed data.īased on comments, this document was modified on and 2 other approaches have been added. There could be many ways for doing and this is just another way of doing it. If our requirement is to do table transpose without creating any additional table then we can do this completely by modeling in HANA studio.
#Sap hana studio label column how to
Jody Hesch beautifully explained how to do Transpose and its use cases in the document ( How To: Dynamic Transposition in HANA) which involves an additional table. This document is prepared based on HANA SPS6 revision 63.