2639497 - Unexpected decimal places in HANA Studio | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2639497 - Unexpected decimal places in HANA Studio

Symptom

The result in HANA Studio shows unexpected decimal places.

For example, a field has data type DECIMAL(20, 5), when you select it, it shows fewer decimal places.

KBA_decimal1.JPG

While you may find the result is different in hdbsql.

 KBA_decimal2.JPG

Also when you convert it to varchar or nvarchar data type, the result has correct decimal places.

 KBA_decimal3.JPG

Due to this issue, you may get unexpected result of decimal precision by 'Data Preview' during modeling.


Read more...

Environment

  • HANA Platform 1.0
  • HANA Platform 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA studio 1.0 ; SAP HANA studio 1.5 ; SAP HANA, platform edition 2.0

Keywords

unexpected result; wrong result; decimal; decimal places; precision; data preview; HANA studio; hdbsql , KBA , HAN-STD-ADM-DBA , SAP HANA Studio (Eclipse) Admin Tooling , HAN-DB , SAP HANA Database , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.