SAP Knowledge Base Article - Public

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


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


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



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


  • This is behaviour by design


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


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


SAP Lumira, desktop edition 1.0