SAP Knowledge Base Article - Public

2539189 - Data is not represented the same when exported to Excel from a crosstab in Lumira Discovery

Symptom

  • Data appears different when exported to a Excel spreadsheet from a crosstab in Lumira Discovery 2.0

Environment

  • SAP Lumira Discovery 2.0 SP02
  • Microsoft Windows
  • Microsoft Excel

Reproducing the Issue

  1. Acquire data from any data source
  2. Import the data into a crosstab (See example in the screenshot below)
    Capture.JPG
  3. Click on the export button from the visulaisation toolbar
  4. Select .xlsx from the "format" drop down menu
  5. Click the export button
  6. Open the Excel spreadsheet (The data appears as below)
    Capture2.JPG

 

Cause

  • This is behaviour by design as Lumria Discovery extracts the data and saves it in Excel format.
  • As the format of the document produced is .xlsx the visualization representation changes in Excel.

Resolution

  • This is behaviour by design

Workaround:

  1. Click on the preview button from Lumira Discovery
  2. Click on the Export button from the toobar
  3. Export the story to PDF

Keywords

Lumira Discovery , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0