Microsoft KB Archive/831352

= PRB: Calculated Member Returns Incorrect Value When You Divide a Currency Data Type Measure with a Real Data Type Measure =

Article ID: 831352

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



Bug #: 14148 (Plato 7x)



SYMPTOMS
When you create a calculated member in a cube that contains an expression that divides a Currency data type measure by a Real data type measure, you may see that the value of the calculated member is incorrect.

You may see this behavior when the calculated member expression involves a division operation between a Currency data type measure and a measure of another data type such as a Double, a Float, or a Numeric.



WORKAROUND
To work around the problem, follow these steps:
 * 1) Change the Currency data type to Double.
 * 2) Set the display format to Currency.
 * 3) Process the cube.

To do this:
 * 1) Start Analysis Manager.
 * 2) In Analysis Manager, locate the cube that you want to modify.
 * 3) Right-click the cube, and then click Edit.
 * 4) In the left pane of the Cube Editor, expand the Measures folder, and then click the measure that you want to change the data type for.
 * 5) On the View menu, click Properties.
 * 6) In the Properties pane, click the Advanced tab.
 * 7) In the Data Type list, click Double.
 * 8) In the Display Format list, click Currency.
 * 9) On the File menu, click Save.
 * 10) On the Tools menu, click Process Cube.

