Hello,
I have a Design Studio 1.6 querying data from an HANA Calculation View (HANA is 1.00.122). I am using the crosstab to allow user navigation. The crosstab has 3 differente KPIs:
First field is a simple sum. The second one has a particular logic to obtain the number displayed and the third is the division of the two. In this image number are correct but when I insert a dimension using Navigation Panel (applying no filter) I have this odd behaviour:
Number for each single row are correct but the total is not. It seems Crosstab component is ignoring logic defined in HANA Calculation view and he is recomputing the total using Sum for first 2 fields and the using division for the third one. On HANA Data Preview on calculation view I cannot see totals anyway.
I really do not know how to solve this strange things; I would like the "Total" row has the same values as the first image before bringin in the dimension.
On another way I would like to know if there is a way in HANA to obtain total for the calculation view "Data Preview" so I can check if I made some mistake while modeling.
Regards,
Leonardo
Sounds like there is a work around - see the replies on this thread: https://archive.sap.com/discussions/thread/3905518
I am not a big fan of the work around so you may want to submit a SAP Support incident
Thank you Tammy! Seems people in thread you pointed out have same problem; I will try the work-around but it seems impossible to me Design Studio is not allowing to properly calculate Totals in Crosstab component.