2365084- Drill Limitation warning: The result is limited to 500 rows (# in total). Limit your result for displaying further data or edit the drill limitation in SAP Analytics Cloud

Symptom

The values on the Story Grid / Table only show up to 500 rows in SAP Analytics Cloud

All values are displayed from Story Data View

The warning message: Drill limitation appearsThe result is limited to 500 rows (718 in total) and 15 columns (1 in total). Limit your result for displaying further data or edit the drill limitation.Edit Drill Limitation

The result is limited to 500 rows (718 in total). Limit your result for displaying further data or edit the drill limitation.Edit Drill Limitation

Environment

SAP Analytics Cloud

Reproducing the Issue

From SAP Analytics Cloud create a story grid or table based on a model with more that 500 rows

From Story> Page check the values displayed within the table

Cause

Drill Limitation is enabled, which limits the maximum number of rows to be displayed.

Resolution

From SAP Analytics Cloud, open a Story and go to Story Page

Select 'Designer' mode

Click the 'Warning' symbol

Click the 'Edit Drill Limitation' button to change the default value to a custom value.