Microsoft KB Archive/927945
Article ID: 927945
Article Last Modified on 2/7/2007
- ProClarity Analytic Server
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.
This issue occurs because the calculated measure uses the currency format in the Microsoft SQL Server Analysis Services cube.
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.
Keywords: kbtshoot kbprb KB927945