I have a cube with the following measures:
*Name *Data Type
StoreSales Currency
UnitSales Decimal

It includes the following Calculated Members
*Name
SalesPerUnit

*Value
[Measures].[Store Sales]/[Measures].[Unit Sales]

When I look at my data, the Sum of StoreSales is
110.42 and UnitSales is 54.62. The SalesPerUnit should be
2.0208, however, the value in my pivot table is 2.0448.
It looks like the calculated member is taking the
StoreSales 110.42 and dividing it by 54 (whole number)
instead of 54.62.

Is this a know issue in Analysis Services?

More Info...If I change the StoreSales Data Type to
Decimal, the formula works. Unfortunately, we have a
large number of cubes that have measures of type currency.