SAP Knowledge Base Article - Public

2464197 - SAP BusinessObjects Cloud gives different total than SAP HANA Studio "Raw Data" View

Symptom

SAP BusinessObjects Cloud gives different total than SAP HANA Studio "Raw Data" View

Environment

  • SAP BusinessObjects Cloud
  • SAP HANA Studio
  • SAP HANA

Reproducing the Issue

  1. Create a complex Calculation View in SAP HANA
  2. Preview the "Raw Data" from the SAP HANA Calculation View in SAP HANA Studio
  3. Notice that Measure1 gives value 10000
  4. Create a Story in SAP BusinessObjects Cloud against the same SAP HANA Calculation View
  5. Notice that Measure1 gives value 5000

Cause

"Raw Data" preview in SAP HANA Studio selects all columns from the SAP HANA Calculation View while SAP BusinessObjects Cloud selects only the columns used in the Story

Additional columns in the "Raw Data" preview can bring in additional linked tables and change the results

Resolution

In order for results in SAP HANA Studio to match the results in SAP BusinessObjects Cloud you must select the same columns in both.

To do this you can retrieve the query from the "Raw Data" view and edit it down to match only the columns used in SAP BusinessObjects Cloud.

  1. Preview the SAP HANA Calculation View in SAP HANA Studio
  2. Click the "Raw Data" tab
  3. Filter down to the row(s) in question and notice the Measure1 = 10000 case
  4. Click "Show Log"
  5. Double-click the last entry which shows your query execution
  6. Click "Copy" to copy the SQL
  7. Click "Close"
  8. Click "Close"
  9. Right-click your server and choose "Open SQL Console"
  10. Paste in the SQL and click execute to see the same data as the "Raw Data" view
  11. Now edit down the SQL to include only the columns used in SAP BusinessObjects Cloud
  12. Notice that Measure1 = 5000 now in both SAP HANA Studio SQL Console and SAP BusinessObjects Cloud

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, data, totals, sum, amount, aggregation, match, mismatch , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0