SAP Knowledge Base Article - Public

2029343 - SAP Lumira views for HANA data are incorrect

Symptom

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.

Environment

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”

 Lumira.PNG

  1. Results with HANA Studio

HANA Studio.PNG

 

Cause

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

Resolution

  • There is currently no target release scheduled for this functionality.
  • It is being reviewed by our Development team for future releases.

Keywords

Lumira DATE TIME, Lumira DATETIME, Lumira 01/01/1970, , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Bug Filed

Product

SAP Lumira, desktop edition 1.0