Skip to Content
0

Design Studio 1.6 - Totals on Crosstab component are not correct

Mar 26, 2017 at 12:12 AM

137

avatar image

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

1.png (3.6 kB)
2.png (13.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Mar 26, 2017 at 09:12 AM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0