SAP Knowledge Base Article - Public

2693764 - BIRT Upgrade 4.3.2 - Error message when opening a report in .xlsx format - Ad Hoc Reporting

Symptom

Run a report offline to Excel format .xlsx and receive a warning message in Excel as follows:

2018-09-13_13-54-31.png

Environment

  • SAP SuccessFactors Workforce Analytics
  • Adhoc Reporting
  • BIRT Upgrade

Reproducing the Issue

  1. Run ReportX
    1. Run Offline
    2. Format: Excel
  2. Go to Scheduled Reports / View Schedules in Report Centre
  3. Open File
  4. See above warning message from Excel: "We found a problem with some content in ReportX.xlsx. Do you want us to try and recover as much as we can? If you trust the source of this workbook, clixk Yes.

Cause

There is no difference in the raw data but there is a difference in the way the data is grouped in a table. In 2.6.0, all the data are grouped under one table but in 4.3.2 the data’s are grouped in multiple tables with same column header based on some size or logic.

Resolution

The message is not actually an error but just a warning. This is the reason why clicking on 'Yes' eventually loads the report.

You may check this link we found from Microsoft that is related to the message that is prompting:

https://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-problem-when-i-turn-on-share-option-on/17379b7c-2100-4ddf-a04d-251cc7a91424?db=5

The translation of the steps is go to 'Review' > Share Workbook > tick the 'Use the old shared workbooks feature instead of the new co-authoring experience.' under the 'EDITING' tab.

2018-09-13_14-32-40.png

Then under the 'ADVANCED' tab > un-tick 'Filter Settings' > OK

ExcelChange.png

See Also

 2684872 - Upgrade BIRT from version 2.6.0 to 4.3.2 - Ad Hoc - Q3 2018

Keywords

Adhoc, Ad Hoc, BIRT, BIRT Upgrade 4.3.2, date/ time, Date Time, BIRT Template, Excel. , KBA , LOD-SF-ANA-BIR , BIRT Reports , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core 1805 ; SAP SuccessFactors HCM Suite all versions