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:
-
- Navigate to the Table within your story.
- Click the three dots (⋮) in the top-right corner of the table to open the table options.
- Select Show/Hide.
- Ensure that Table Details is checked.
- A warning message will appear at the top-left corner of the table.
- Hover over the information (i) icon to display the edit drill message.
- Click Edit Drill Limitation to adjust the number of rows you would like to display.
- There are several enhancements regarding this feature available for voting. Feel free to vote on them:
https://influence.sap.com/sap/ino/#/idea/281341 - https://influence.sap.com/sap/ino/#/idea/283365 - https://influence.sap.com/sap/ino/#/idea/245725
See Also
- 2899032 The drill limitation warning message always displays in the story in SAP Analytics Cloud (SAC)
- https://community.sap.com/t5/technology-q-a/sap-analytics-cloud-limitations-in-story-tables/qaq-p/12373366
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Getting Started with SAP Analytics Cloud
- Need More Help? Contact Support or visit the solution finder today!
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
SAP Knowledge Base Article - Public