SAP Knowledge Base Article - Public

2503795 - Crosstab limit in Lumira Discovery 2.0

Symptom

  • Importing data which contains over 100,000 rows only shows 100,000 rows in the crosstab.
    For example if 300,000 rows worth of data is imported into a crosstab in Lumira Discovery only 100,000 rows would be visible.
    See the "Running Count" column in the image below:
    count.JPG

Environment

  • SAP Lumira Discovery 2.0 SP01
  • SAP Lumira Discovery 2.1 SP01

Reproducing the Issue

  1. Import data containing over 100,000 rows
    rows.JPG
  2. Click on the "insert chart" button and select "crosstab"
  3. Drag the required dimensions and measures into the crosstab
  4. Click on the calculations button and select "running calculations"
  5. From the "Running Kind" drop down menu select "Count"
  6. Scroll down to the bottom of the Cross tab

Cause

  • Lumira Discovery is a tool used for creating visualizations and not tailored for reporting therefore there are restrictions on the amount of data displayed in a crosstab

Resolution

Upvote the enhancement request to allow the crosstab to display all rows of data in Lumira Discovery at SAP ideas place:
https://ideas.sap.com/D44046

See Also

2468341 - Lumira becomes unresponsive once a crosstab is added into the compose room

Keywords

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

Product

SAP Lumira, desktop edition 1.0