SAP Knowledge Base Article - Public

3567825 - How to access the setting for Drill Limitation for story tables in SAP Analytics Cloud (SAC)

Symptom

  • How to access and update the setting for Drill Limitation for story tables in SAC

Environment

  • SAP Analytics Cloud

Resolution

  • To access this Drill Limitation in story tables, it is required to encounter a warning message like under Table Title: 
    Warnings: Drill Limitation
    XXX rows of data are requested, but the result limit is set to 500 rows and 60 columns. To display the expected data, either filter your results or edit the result limitation.
    Edit Drill Limitation
  • If the warning message is not visible within the table, please ensure that you:
    1. Navigate to the Table within your story.
    2. Click the three dots (⋮) in the top-right corner of the table to open the table options.
    3. Select Show/Hide.
    4. Ensure that Table Details is checked.
    5. A warning message will appear at the top-left corner of the table.
    6. Hover over the information (i) icon to display the edit drill message.
    7. Click Edit Drill Limitation to adjust the number of rows you would like to display.

See Also

Keywords

drill level, setting, table, design, limitation, warning, SAC, SAP Analytics Cloud, SAC troubleshooting, SAC connection error, SAC data import issue, SAC model setup, SAC live connection, SAC acquisition connection, SAC tenant configuration, SAC authentication error, SAC integration issue, SAC dashboard creation, SAC performance optimization, SAC error handling, SAC system outage, SAC data modeling, SAC user access issue, SAC connectivity troubleshooting, table , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-TAB , Table , How To

Product

SAP Analytics Cloud 1.0