SAP Knowledge Base Article - Public

3563348 - Data Analyzer : No "Edit Drill Limitation" option in Data analyzer

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":
    Drill_option_Story.jpg
  • 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
    Drill_option_DAN.jpg

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

  1. There is no "Edit Drill Limitation" in the Data Analyzer:
    1. In Data Analyzer only a limited window is fetched at one point in time.
    2. As soon as scroll down, the missing data is fetched and displayed.
    3. 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).
  2. 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.
    1. If selecting all these measures in story, you will have the same issue, too, regardless of whether a drill limitation is set or not.
    2. 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

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

Product

SAP Analytics Cloud all versions