Symptom
- Having 25 dimensions and 50 measures in an insight Data analyzer, we get a warning message as "Rendering issue in Result Set".
There is no data shown in the Data Analyzer. - The expectation is when using the same number of dimensions and measures for a table in the story ODE, we get a warning about "Drill limitation" where we can edit and change value to "Unlimited":
- Same behavior is expected for a table in Data analyzer, but instead, the message "Rendering issue in Result Set" or "Result is much larger than returned page" is displaying
Environment
- SAP Analytics Cloud (Enterprise)
Cause
In Data Analyzer, the overall limitation of rows and columns is not restricted the same way as in story, as the data analyzer supports incremental loading. Even if there are only 150 rows and 15 columns loaded initially, additional rows are loaded as you scroll down/right in the table.
Additional information :
- when opening from the story and jumping to the data analyzer, some zero/null suppression is activated.
- When opening the data source from scratch in the data analyzer, this zero/null suppression is not activated.
Resolution
- There is no "Edit Drill Limitation" in the Data Analyzer:
- In Data Analyzer only a limited window is fetched at one point in time.
- As soon as scroll down, the missing data is fetched and displayed.
- This is working as designed. The only issue here is the confusing warning displaying (and which is going to be suppressed in the upcoming release that is scheduled for May 2025).
- The issue of not seeing any data at all in the Data Analyzer (and getting the error message "Rendering issue") is not only dependent on the amount of dimensions selected, but also on the amount of measures selected.
- If selecting all these measures in story, you will have the same issue, too, regardless of whether a drill limitation is set or not.
- More details for this can be found in sap note 2770570 (Error message "The select returned more records than the limit in MaxResultRecords" / MDS Cube resultset & cell size limit).
See Also
- 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 a case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
Drill limitation, Rendering, Data Analyzer, MaxResultRecords , KBA , LOD-ANA-DAN , SAC Data Analyzer , Problem