Loading

Different Measure Values Results When Connecting to SAP HANA Live vs. Extract

Publiseringsdato: Apr 13, 2024
Beskrivelse
Measure values do not match when connecting to a SAP HANA calculation view live vs. creating an extract of the data source.

Cause

If a SAP HANA calculation view is based on multiple raw tables, then mixing fields from the various tables can lead to incorrect results.
Løsning
As a workaround, try to emulate the different tables that make up the SAP HANA calculation view inside different Tableau extracts. The goal would be to have one extract that contains only fields from the one table.

To do so, please follow the steps below:
  1. Connect to the live data source.
  2. Create the view.
  3. Click "Hide all unused fields" from the drop-down on the Data pane menu. For more information, see Hide or Unhide Fields.
  4. Create an extract by right-clicking the data source and selecting Extract data. 
  5. Repeat above steps for each required view.
  6. Combine the views on a dashboard. Each view will be based on its own extract.
Flere ressurser
The level of aggregation within the calculation view (e.g. what you usually would call the "GROUP BY" clause) is dynamically adjusted based on the columns a SELECT against the view contains. This is what SAP calls "non-relational" behaviour - and it is. It's not at all working like an aggregation over a sub-select.

If Tableau creates an extract based on all the columns, this will have a different level of aggregation than a live-query that picks only some of the columns. This really is SAP HANA specific behaviour, and there are options to avoid this in the calculation view. Specifically, one can fix the level of aggregation by using the "keep" flag.

For details on that, this blog post (and linked examples) is a good start:

Usage of “Keep Flag”
https://blogs.sap.com/2017/08/30/usage-of-keep-flag
Knowledge-artikkelnummer

001472797

 
Laster
Salesforce Help | Article