Why does the aggregation from HANA calculation view not carry over into Lumira?

[mrwong05]

My aggregation types in my HANA server (version 1.00.112.04.1467296086) do not carry over to Lumira (Desktop 1.31.7) when the Calculation view is loaded through HANA Database source.

I found this about lumira from the user guide https://saplumira.com/app/uploads/2016/11/lum_131_user_en.pdf: " 3.5.1.1 Restrictions for Connecting to SAP HANA When connected to an SAP HANA online data source, the following restrictions apply: ● The Change Aggregation action that is typically available for each measure in the Measures and Dimensions panel is not available. "

Also I am not able to change the aggregation on Lumira Desktop. Can someone tell me why this is the case and how I can get the aggregations i want (average)

Thank you,

Matt

[mrwong05]

So I've come across this related problem:

When I add the measure Height, and dimension ICD1, the average height is given, as expected.

but as soon as i use a filter to remove the 0s or blanks the measure becomes a sum and not an average of the remaining.

[TammyPowlas]

Is this an online HANA connection or?

[mrwong05]

The connection is to an "online" remote HANA DB. I'm not sure what you mean by "online", but the connection is live.

[TammyPowlas]

Hi - thank you for these details; I would submit an incident with SAP Support at support.sap.com - I can't find anything and I agree the aggregations should carry over.

[former_member183750]

Answered in the following KBA:

2517067 - Hana aggregation options different or missing when query used in Lumira Desktop


- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

SAP is now offering chat support. For more details please see KBA2213344 - How to start a chat with SAP Support[video]

Follow me on Twitter:https://twitter.com/crnanalysistips

[mrwong05]

So you are saying these behaviors are by design. Hana online connectivity does not support changing the aggregation type -- Will it in 2.0?

[former_member277290]

Hi, Ludek,

Thanks for pointing out the above. I am also interested in hearing any suggestions for an actual solution to this, as it caught me by surprise.

There are many measures for which it is almost never useful to have 'sum' aggregation, for example: price or temperature.

I am surprised Lumira cannot manage these with a live connection, considering HANA supports pushdown of aggregation, and the fact that the calc views are explicitly set to AVG aggregation.

So if Lumira does not support this, please could you suggest how we might model the calc view differently, or any other alternative method to produce the kinds of visualisations which are actually useful with these measures?

Please could you help us understand the reasoning behind this 'by design' restriction?

Kind Regards.

[former_member184969]

I'm also in for updates on this...