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

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:

Change the Currency data type to Double.
Set the display format to Currency.
Process the cube.

To do this:

Start Analysis Manager.
In Analysis Manager, locate the cube that you want to modify.
Right-click the cube, and then click Edit.
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.
On the View menu, click Properties.
In the Properties pane, click the Advanced tab.
In the Data Type list, click Double.
In the Display Format list, click Currency.
On the File menu, click Save.
On the Tools menu, click Process Cube.

REFERENCES

For additional information about a related topic, click the following article number to view the article in the Microsoft Knowledge Base:

308968 FIX: Incorrect Results Occur When You Use Currency Data Type with Very Large Value