SAP Knowledge Base Article - Public

2136613 - SAP Lumira 1.23 shows no data for Visualization that worked in 1.22

Symptom

SAP Lumira 1.23 shows no data for Visualization that worked in 1.22

Environment

SAP Lumira 1.23

Reproducing the Issue

  1. Launch SAP Lumira 1.22
  2. Create a new document on a Data Source with a datetime string
  3. Go to the Visualize room
  4. Convert the datetime string to date
  5. Create a Measure from a Count of the date
  6. Use the Measure in the Visualization
  7. Save the document
  8. Open the document in SAP Lumira 1.23
  9. Notice that the Visualization shows no data

Cause

SAP Lumira 1.23 calculation engine returns NULL for a datetime string when try to convert it to a date

Resolution

  1. Create a Calculated Dimension with formula “SubString({Datetime String}, 1, 10)”
  2. Do a Convert to Date on the Calculated Dimension
  3. Create a Measure on the Converted To Date dimension
  4. Replace the old measure in the visualization with the new measure

Keywords

  • blank
  • empty
  • Lumira Desktop
  • no data
  • date time
, KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0