https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/927945&feed=atom&action=history
Microsoft KB Archive/927945 - Revision history
2024-03-29T12:32:50Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/927945&diff=225412&oldid=prev
3155ffGd: importing KB archive
2020-07-18T17:34:26Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB927945"></span>In ProClarity Analytics Server 5.3, the result is incorrect when you divide a decimal number by a calculated measure in an MDX definition =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 927945<br />
<br />
Article Last Modified on 2/7/2007<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* ProClarity Analytic Server<br />
<br />
<br />
-----<br />
<br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
When you divide a decimal number by a calculated measure in a Multidimensional Expressions (MDX) definition, the result is incorrect in ProClarity Analytics Server 5.3. The result is calculated without using the decimal point in the decimal number. For example, the result of 100.00 divided by 0.5 is 20,000 instead of 200.<br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
This issue occurs because the calculated measure uses the currency format in the Microsoft SQL Server Analysis Services cube.<br />
<br />
</div><br />
<div class="resolution_section"><br />
<br />
== RESOLUTION ==<br />
<br />
To resolve this issue, use the '''VAL''' function in the MDX definition for the calculation. The '''VAL''' function explicitly instructs Analysis Services to use the decimal number.<br />
<br />
</div><br />
Keywords: kbtshoot kbprb KB927945<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd