Unexpected data showed by a frontend or client tool, where the BICS acting as the middle layer to access the HANA Views (e.g. Lumira Designer, Design Studio). The same behaviour persist, by consuming the HANA Views with JDBC SQL or HANA HTTP. Some HANA Expression functions, used in Calculated columns may end up a different result as soon as BICS involved (Designer Edit Initial View), than in HANA modeller data preview.
For example a rounding function can be a typical scenario to present the difference:
SAP BusinessObjects Lumira Designer 2.x
SAP BusinessObjects Design Studio 1.x
SAP HANA DATABASE
round, function, expression, BICS, INA, HANA http, JDBC SQL , KBA , BI-LUM-DER , Lumira Designer , BI-RA-AD-HAN , HANA Integration , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.