on 02-06-2015 12:07 AM
Hello Colleagues & Community,
I have a data column in HANA DB related to duration. For example, I have instrumented a mobile library, and am recording the results of various timers, together with information on the current conditions.
Since I am interested in a statistical view of the values, I would like to use a Box Plot in SAP Lumira (MIN, Q1, MED, Q3, MAX). I am exposing the data to Lumira via an Analytic View created in SAP HANA Studio. The Analytic View logically joins a data foundation containing the fact and dimension tables, with a time-series attribute view.
The issue or question that I am running into is: How can I define a measure on the duration column in the Analytic View, without specifying an Aggregation (COUNT, SUM, MIN, MAX) type?
The reason I think I want this, is that Lumira should be able to access the raw data points of the duration column, in order to calculate the Box-Plot quartiles. Instead, I'm seeing it attempt to calculate quartiles on the SUM of the duration column over the period, and it's just returning the SUM for all quartile values--a horizontal line.
Any ideas?
Thanks!! Stan
Screenshots:
Here is the raw data in HANA Studio
Here's the Semantic definition of the Analytic View (TIMERDURATION has Aggregation options: SUM, MIN, MAX, COUNT)
And, here's the Box Plot in Lumira (note that both values are the sum of the raw data above)
Hi,
in lumira desktop, are you able to go to the Measure > Change aggregation > and use None ?
regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi that looks exactly right--for created measures-- and I can see the documentation here: Creating a measure from a column or a dimension - About SAP Lumira - SAP Library.
However, the "Create a measure" option is disabled on the target column. It's a numeric type... I see a note that I must be in Facets mode, and I think I am... does this look familiar?
Thanks,
Stan
For online HANA views, aggregation is done natively on HANA server side, which itself does not support None as an aggregation type. This is also a restriction when publishing an offline dataset to HANA containing a measure with Aggregation type None (page 129, http://help.sap.com/businessobject/product_guides/vi01/en/lum_122_user_en.pdf).
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.