Incorrect Totals for HANA calculated measure counter(count distinct)

[former_member198590]

I created HANA calcview which have calculated measure as counter(count distinct). After that I use this calcview as datasource in Design Studio.

In initial view I added dimension, so I can see this calculated measure for all dimension members - everything OK, but "Total result" displayed incorrect because its not sum and have to be "count distinct".

I have checked this situation in Analysis for MS Office - it works correct, WebIntelligence - correct too.

Does somebody experienced such issue?

[Former Member]

Hi Andrey,

Are you find any solution to show "Total Result" in CrossTab, Even I am also facing the same issue.

Thanks,

Thiru.G

[Former Member]

Andrey - We are facing the same issue. Did you find a solution yet?

[former_member198590]

No, only workaround:

1. DS_1 with dimension in rows: I hided totals and bind it to Crosstab
2. added DS_2 without dim in rows to get correct Totals and bind measure values to TEXT component