SAP Knowledge Base Article - Public

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 appears
    The 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

Table_limit_warning.png

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. From SAP Analytics Cloud create a story grid or table based on a model with more that 500 rows
  2. 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

  1. From SAP Analytics Cloud, open a Story and go to Story Page
  2. Select 'Designer' mode
  3. Click the 'Warning' symbol
  4. Click the 'Edit Drill Limitation' button to change the default value to a custom value.
Warnings.png 14-Jul-17 12-40-49 PM.png

       

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

limit, many, rows, columns, crosstable, table, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, SAC , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , Problem

Product

SAP Analytics Cloud 1.0