2616367 - HANA functions may show different result in Lumira Designer

Symptom

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:

Environment

SAP BusinessObjects Lumira Designer 2.x
SAP BusinessObjects Design Studio 1.x
SAP HANA DATABASE

Product

SAP BusinessObjects Design Studio 1.3 ; SAP BusinessObjects Design Studio 1.4 ; SAP BusinessObjects Design Studio 1.5 ; SAP BusinessObjects Design Studio 1.6 ; SAP BusinessObjects Lumira 2.0 ; SAP Lumira 2.1

Keywords

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 page

This 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.