3295015 - Missing results/columns in Story table widget due to Drill Limitation

Not all results/columns are showing up when running a table widget in Story report.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

• SAP SuccessFactors HCM Suite
  • Analytics & Reporting
    • Story Report

1. Login to the instance
2. Navigate to Reporting
3. Run a Story report that has a table widget
4. Notice that not all results/columns are showing up in the table when attempting to scroll down to the bottom.

This occurs because of a default drill limitation, restricting results to 500 rows and 60 columns. This measure is in place to ensure fast loading times and optimized performance.

To increase the limit:

1. Access the Drill Limitation option through the warning icon on the top of the table widget:
   
   
   
   
2. On the pop up window, select 'Custom'.
3. Adjust the drill settings according and click 'OK'.
   
   

Note: 

• Make sure the cell limit box is checked to avoid performance issues; More than 30000 cells can cause the entire report page to halt.
• It is also not recommended to use Unlimited option.
• When the drill limitation is changed in edit mode, saving the story will retain these settings per table—ensuring the same configuration is applied for future exports and visible to viewers 

2881269 - Drill Limitation in Table

3016761 - Only 500 rows data can be displayed in embedded SAC story even if the CDS view in S4 HANA cloud contains more data rows

3251833 - How to export Story report data [People Analytics] - SAP for Me

drill limitation, table widget, story report, 500 rows, 60 columns, hard limit, unlimited, custom, missing results, not listed, showing up , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To

SAP SuccessFactors HCM Suite 2511 ; SAP SuccessFactors Platform 2511