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.
While you may find the result is different in hdbsql.
Also when you convert it to varchar or nvarchar data type, the result has correct decimal places.
Due to this issue, you may get unexpected result of decimal precision by 'Data Preview' during modeling.
HANA Platform 1.0
HANA Platform 2.0
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 pageThis 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.