1528403 - BIOD Excel datasets error or stall when being uploaded to bi.ondemand.com

SAP Knowledge Base Article - Public

1528403 - BIOD Excel datasets error or stall when being uploaded to bi.ondemand.com

Symptom

When a dataset based off of an Excel spreadsheet is being uploaded to bi.ondemand.com, the upload stalls and eventually errors with "Something went wrong"

Resolution

Excel workbooks containing a number of unused worksheets will occasionally fail when being uploaded.  Please follow the steps outlined to ensure a succesfull upload.

  1. Open the Excel workbook
  2. Scroll to the bottom of the worksheet.
  3. Right click on any unused worksheets that are part of the Excel workbook.
  4. Select "Delete" from the dropdown choices.
  5. Repeat for any unused worksheets.
  6. Save the Excel file.
  7. Upload to  bi.ondemand.com

Keywords

KBA , BI-OD-BI , Business Intelligence OnDemand , Problem

Product

SAP Crystal Reports XI R2