3693346 - High mds statements (>700 GB) caused by widget in some story in SAP Analytics Cloud (SAC)

• The SAC tenant is experiencing high MDS statements (>700 GB) caused by a widget labeled "udm" in the Story.
• The widget does not have a specific name, ID, or description in the story.
• Story is based on Datasphere live data connection.
• The phenomenon impacts story performance and could significantly affect the system if it worsens.

SAP Analytics Cloud 2025.22

1. Log in to SAC, run story.
2. In Datasphere, go to System Monitor > Statement Logs, and sort "SAP HANA Peak Memo" with descending order.
3. Check the MDS monitor in Datasphere and observe resulting MDS statements with 500-700 GB for the widget.

• The issue is caused by the dynamic text widget querying calculated dimensions without an explicitly defined measure context. This results in the inclusion of all available measures in the query payload, leading to high memory consumption.

• Remove dynamic text widgets from affected stories to temporarily mitigate the issue.
• Avoid using calculated dimensions in dynamic text widgets or other widgets unless absolutely necessary.
• Monitor the system during high-traffic periods, such as weekends, to identify potential memory spikes.

high mds statements, widget, story care retail b&, sap analytics cloud, sac qrc-3 update, dynamic text error, large mds files, statement logs, dsp monitor, query batch, support user creation, scoped roles , KBA , LOD-ANA-DES-TXT , SAC Story Text Widget and Dynamic Text , Problem