2332881 - Lumira data type mismatch connecting to .csv files (HDB 07500)

SAP Knowledge Base Article - Public

2332881 - Lumira data type mismatch connecting to .csv files (HDB 07500)

Symptom

  • Dimensions <dimension> and <dimension> do not have the same data type. (HDB 07500)
  • Incorrect data type for a column
  • Number type instead of String type
  • Quotes around numbers in .csv are getting ignored

Environment

  • SAP Lumira 1.30

Reproducing the Issue

  1. Connect Lumira to a .csv file where one of the columns has number values in quotes like "123"
  2. Notice the column displays as a Number type

Cause

By design SAP Lumira treats the .csv file data types the same way as MS Excel. To confirm, open the same file in MS Excel and check the datatype.  

Resolution

Workaround Solution:

  1. Open the .csv file in MS Excel
  2. Change the data type of the column to text
  3. Save the file with .xlsx extension
  4. Connect Lumira to .xlsx file

Keywords

datatype, string, integer, convert, wrong type , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0