2029343 - SAP Lumira views for HANA data are incorrect

SAP Knowledge Base Article - Public

2029343 - SAP Lumira views for HANA data are incorrect


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

  1. Open Lumira
  2. Create a new Dataset wirh Query with SQL
  3. Select SAP HANA database
  4. Set credentials
  5. Preview table contain the objects define with “DateTime”
  6. This object is displayed like “1/1/1970”


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


SAP Lumira, desktop edition 1.0