Symptom
When user click on the "Excel" export button on a YouCalc Dashboards, cannot export tile drilldown with excel format
Environment
- SAP SuccessFactors HCM Suite
- SAP SuccessFactors Analytics
-
Youcalc Tile, Dashboard 2.0
Reproducing the Issue
1. When run a YouCalc Dashboard, issue only happens if select "All" or the pie part that has greater value.
2. Please note that as per Reporting Best Practice, export with xls format (which is the default format of Tile/Dashboard export) is only limited to 65536 rows.
3. When the pie/chart part that has greater value has over 65536 rows data which already exceeded the maximum allowable rows for xls. It will unable to download while click on "Excel" button.
Cause
Issue is expected behavior as it exceeded the max rows allowed for the xls. file format.
Microsoft Excel limitation in rows for XLS is 65536.
2418819 - Reports Best Practices & Restrictions for Table and Canvas reports
Resolution
1. Utilized CSV option
2. Use filters to limit result of the reports less than 65536 rows.
See Also
2418819 - Reports Best Practices & Restrictions for Table and Canvas reports
Keywords
YouCalc, Excel. xls, export , KBA , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Product Enhancement