Skip to Content
0

Viewing Calculation View with non-additive measures in Excel - incorrect totals

Jan 30, 2017 at 05:40 AM

80

avatar image

I've built a calculation view in SAP HANA 2.0, and have a measure which is a ratio and therefore not additive - the measure is calculated on the lines of '<actual measure> / <target measure>' and represents an efficiency metric. I've places this calculated measure in my 'star join' node, so it is calculated AFTER any aggregations (which is intended). Hana calculates this measure correctly for various aggregation levels.

I then attempt to view this calculation view through Excel. I'm using the MDX driver, and create a connection to the calculation view. If I simply view the measure on its own (without any dimensions), I get the correct aggregated value for the ratio for all data. However, as I start to place dimensions on my pivot table, it appears that Excel is calculating sub-totals and grand totals using 'SUM', and ignoring the fact that this measure's aggregation is set to 'FORMULA'. Is this an issue with Excel - can I force Excel to fetch sub-totals and grand totals from HANA instead of appearing to perform a client-side aggregation? In my settings for the calculated measure, I have 'enable client side aggregation' set to unchecked.

At this point, not sure whether Excel or HANA issue?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers