Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS

FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS

View products that this article applies to.

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 memory if it uses the  "/" operator. 

↑ Back to the top

Cause

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

↑ Back to the top

Resolution

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

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

References

Learn about the terminology that Microsoft uses to describe software updates.

↑ Back to the top

Keywords: kbfix, kbqfe, kb

↑ Back to the top

Article Info
Article ID : 4560494
Revision : 6
Created on : 5/15/2020
Published on : 5/15/2020
Exists online : False
Views : 197