1525949 - Adding a data set based off of an Excel file fails with an error.

SAP Knowledge Base Article - Public

1525949 - Adding a data set based off of an Excel file fails with an error.

Symptom

When an Excel spreadsheet is used as the data source for a new dataset in bi.ondemand.com,  the data set fails to upload to bi.ondemand.com.  An error indicating "Something went wrong" appears after a long wait.

Cause

Excel workbooks containing unused worksheets can occasionally prevent the xls file from being uploaded to bi.ondemand.com.

Resolution

Please follow the steps outlined below:

  1. Open the Excel workbook.
  2. At the foot of the workbook, click on any unused worksheets.  Note, typically there will be 2 unused worksheets as a default.
  3. Right click on the unused worksheet and select "Delete"
  4. Repeat for subsequent unused worksheets.
  5. Save the Excel file
  6. Re-upload the xls file to bi.ondemand.com

Keywords

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

Product

SAP Crystal Reports XI R2