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.
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.
Read more...
Environment
-
HANA Platform 1.0
-
HANA Platform 2.0
Product
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.