on 03-15-2016 11:28 AM
Hi All,
I have noticed "Enable Client Side Aggregation" Check box during calculated column creation in Calculation view.
Please let me know what is the use case for this?
If this check box is not enabled, Client Aggregation became Formula. After Enabling this Client Aggregation is changed to SUM, MIN, MAX.
So It looks like "Calculate Before Aggregation" Option.
Then what is the difference between this two?
Regards,
Muthu
I use "Enable client side aggregation" when I need a column to be calculated as a final step, after other measures have been aggregated.
For example, imagine a calculated column PLAN_HEALTH_INDICATOR that calculates "GREEN", "YELLOW" or "RED" based on PLAN_COMPLETE_RATIO, a ratio derived from two other measures: Aggregated by Plan Name, the indicator will return the color for each plan. But when you don't include Plan Name, you want a health indicator across *ALL* plans. You expect HANA to sum the measures for all plans and base PLAN_HEALTH_INDICATOR on that ratio.
If you define PLAN_HEALTH_INDICATOR as an attribute, then in SQL you have to either include it in your GROUP BY clause or aggregate it with MIN() or MAX(). Either way, it doesn't return what you want - GROUP BY yields 3 rows (for GREEN, YELLOW and RED), and MIN() or MAX() returns "GREEN" and "YELLOW" respectively.
Checking "Enable client side aggregation" directs HANA to calculate the % ratio for all records and base PLAN_HEALTH_INDICATOR on the aggregated result.
The awkward part is that, in SQL, you still need to apply MIN() or MAX() to PLAN_HEALTH_INDICATOR because it's a measure. But it returns the same correct result whether you use MIN() or MAX().
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Documentation says:
If you want to create a calculated measure and enable client side aggregation for the calculated measure, select the Enable client side aggregation checkbox. This allows you to propose the aggregation that client needs to perform on calculated measures. 😛
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.