Skip to Content

How to define measure in HANA Studio for Lumira Box Plot

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)



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 06, 2015 at 11:46 AM

    Hi,

    in lumira desktop, are you able to go to the Measure > Change aggregation > and use None ?

    regards,

    H

    Add comment
    10|10000 characters needed characters exceeded