Skip to Content

AO 2.2 - Measures differ from HANA Studio and Lumira results

[Edit 5/31/2016 - this item is now an in-progress SAP Incident]

From a HANA Live Calculation View designed to return transaction measures based on matching string values (CALWEEK), I'm finding that HANA Live and Lumira (1.28) agree on the value of the measure, but Analysis for Office fails to populate certain measures correctly.

Any suggestions for investigation appreciated.

Within the Calculation View, the formula implicated is


where Tran_CALWEEK is sourced from transaction records linked to HAHA Live M_TIME_DIMENSION

and CALWEEK_M01 is sourced from HAHA Live M_TIME_DIMENSION using the NOW() function to select every seventh day.

When CALWEEK_M01 is forced to static text (i.e. '201613' ), the measures are passed through to AO

The successful matching of CALWEEK values appears in the Data Preview of the suspect join within the Calculation View:

An illustration of the end effect:

HANA Studio

Lumira 1.28

AO 2.2

AO_Hana_Live.JPG (87.4 kB)
AO_Lumira.JPG (56.7 kB)
AO_AO.JPG (61.3 kB)
Capture.JPG (55.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 08, 2016 at 06:59 PM

    Reply Customer - 08/08/2016 11:37:22 - Peter Schubert :

    I find I am unable to reproduce the error described. While it is possible manipulation of the calculation view resulted in a change in conditions, another significant change in condition has occurred.

    On 7/13/2016, the HANA server was updated:

    • upgrade HANA 1 SPS10 (
    • upgrade to SLES 11SP4
    Add comment
    10|10000 characters needed characters exceeded