SAP Knowledge Base Article - Public

3384484 - YouCalc Dashboards - unable to download xls. format file report while click on "Excel" button

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

Product

SAP SuccessFactors HXM Core 2305