An object defined with a type “DATE TIME” in HANA Database is displayed like “01/01/1970” in Lumira when setting a New Dataset “Query with SQL” with HANA.
SAP Lumira 1.15.1
Reproducing the Issue
- Open Lumira
- Create a new Dataset wirh Query with SQL
- Select SAP HANA database
- Set credentials
- Preview table contain the objects define with “DateTime”
- This object is displayed like “1/1/1970”
- Results with HANA Studio
This is a limitation of Lumira desktop as it was not designed to work with time fields.
This has been added as an enhancement request.
There is currently no target release scheduled for this functionality.
It is being reviewed by our Development team for future releases.
Lumira DATE TIME, Lumira DATETIME, Lumira 01/01/1970, , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Bug Filed