大网数据广告活动
数据库与应用安全

MDX query with calculated measure runs slowly

· 52CE 我爱测

This article provides a resolution for the problem when a Multidimensional Expressions (MDX) query is executed with a calculated measure in SSAS 2016, 2017 and 2019 tabular instance.

This article helps you resolve the problem when a Multidimensional Expressions (MDX) query is executed with a calculated measure in SSAS 2016, 2017 and 2019 tabular instance.

Applies to:   Analysis Services, SQL Server 2016, SQL Server 2019, SQL Server 2017 on Windows, Analysis Cubes
Original KB number:   4560494

Symptoms

When a Multidimensional Expressions (MDX) query is executed with a calculated measure in SSAS 2016, 2017 and 2019 tabular instance, the calculated measure runs slow and consumes lots of memories if it uses the / operator.

Cause

An improved DIVIDE function allowing faster performance is available in both MDX and DAX. ​

Resolution

Use the DIVIDE function instead of the / operator in the calculation.

References

terminDescription of the standard terminology that is used to describe Microsoft software updatesology

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 01/14/2021
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。