Symptom
SAP Lumira 1.23 shows no data for Visualization that worked in 1.22
Environment
SAP Lumira 1.23
Reproducing the Issue
- Launch SAP Lumira 1.22
- Create a new document on a Data Source with a datetime string
- Go to the Visualize room
- Convert the datetime string to date
- Create a Measure from a Count of the date
- Use the Measure in the Visualization
- Save the document
- Open the document in SAP Lumira 1.23
- 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
- Create a Calculated Dimension with formula “SubString({Datetime String}, 1, 10)”
- Do a Convert to Date on the Calculated Dimension
- Create a Measure on the Converted To Date dimension
- Replace the old measure in the visualization with the new measure
Keywords
- blank
- empty
- Lumira Desktop
- no data
- date time
Product
SAP Lumira, desktop edition 1.0