SAP Knowledge Base Article - Public

3502348 - Dimension Comment Slow Loading in SAP Analytics Cloud

Symptom

  • Dimension Comments load slowly.
  • Requests to the "commenting" API take longer than expected.
    • For example, requesting ≈250 Dimension Comments may take >45 seconds.
        

Environment

  • SAP Analytics Cloud Version 2024.15

Reproducing the Issue

  1. Open a Table that involves querying >100 Dimension Comments.
  2. Observe poor performance by the "Commenting" API via the DevTools Network Panel. Refer to Network panel: Analyze network load and resources  |  Chrome DevTools  |  Chrome for Developers for detail.

Cause

  • When Dimension Comments are viewed with a different Hierarchy than the Hierarchy used during the creation of the Dimension Comment, slow query performance may occur.
  • Note:
    • This slowdown is due to how data is stored on the backend. 
    • This slowdown is generally negligible for N<100, though as N increases this phenomenon will be increasingly noticeable.
        

Example:

  1. Let us create "Comment X" when the Tables Date Dimension has Hierarchy "Year, Half-Year, Quarter"
        
  2. Now imagine the Tables Date Dimension Hierarchy is changed to "Year, Quarter"
        
  3. As a result of the Commets Hierarchy being different than the Hierarchy used during comment creation, an additional computation step is required to query the Dimension Comment. This additional compare step may result in poor query performance.

Resolution

  • To mitigate the burden of this technical limitation, Dimension Comments should be created where the Tables Dimension Hierarchies are already in their desired viewing state.
  • At this time there is no solution to resolve this performance issue. Existing code architecture must be significantly revised.

See Also

Keywords

comment slow query performance dimension commenting data point , KBA , LOD-ANA-CMT , SAC collaboration, commenting , Problem

Product

SAP Analytics Cloud 1.0

Attachments

Pasted image.png
Pasted image.png