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:
- Open the Excel workbook.
- At the foot of the workbook, click on any unused worksheets. Note, typically there will be 2 unused worksheets as a default.
- Right click on the unused worksheet and select "Delete"
- Repeat for subsequent unused worksheets.
- Save the Excel file
- Re-upload the xls file to bi.ondemand.com
Keywords
KBA , BI-OD-BI , Business Intelligence OnDemand , Problem
Product
SAP Crystal Reports XI R2