SAP HANA and BusinessObjects Explorer

  • by Rakesh Kalyankar, SAP NetWeaver BW- and HANA-certified consultant, SAP
  • February 3, 2014
Learn about how SAP HANA and SAP BusinessObjects visualization panel data is shared.

SAP HANA data in the BusinessObjects Explorer visualization panel and the facets panel cannot match at times. This means the same data in the same report run at the same time was not the same.

The difference is not too much — it is almost always less than 1 percent, which leads to suspicion that this could be a possible rounding issue.

Here is this is the reason for the data mis-match: Explorer sends out two SQL queries internally to the database: One for the facets part and one for the visualizations part. These queries are sent sequentially, and there is a time lag between when the queries are fired.

Rakesh Kalyankar

Rakesh Kalyankar is an SAP NetWeaver BW- and HANA-certified lead and architect, working with SAP Global Delivery in Bangalore, India. He speaks regularly at events, such as SAP TechEd and BIIG. He is also an SAP trainer and writes frequently about SAP NetWeaver BW and SAP HANA topics. Prior to his starting his consulting work, he was part of the SAP NetWeaver BW research and development team at SAP Labs, and he has worked on the development life cycles of SAP NetWeaver BW releases, including versions 7.30 and 7.03.

If you have comments about this article or would like to submit an article idea, please contact the BI editor.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.