FIX: Incorrect Results Occur with Write Back of Different Data Types (308955)

SYMPTOMS

If you use the writeback method to write back to an Analysis Services cube that has a measure stored as a specific data type such as double or currency and you also update the cube with a different data type such as integer, you may experience incorrect results when you query the cube, after the write back.

For example, the following Multidimensional Expression (MDX) statement updates a cube with the value of 200000, which is an integer value. This produces incorrect results for any MDX query that you run after the update or write back, because the measure Budget Dollars expects a currency data type, such as 200000.00.

UPDATE CUBE [Budget] SET ( [Measures].[Budget Dollars],
 [Time].[Year].&[2000], [Product Line].[All Product Line],
 [Customer].[Country].&[Canada].&[Cliffside] ).VALUE = 200000 
USE_WEIGHTED_ALLOCATION BY ( Cousin( [Time].CurrentMember, 
[Time].[Year].&[1999] ), [Product Line].CurrentMember, 
[Customer].CurrentMember ) / ( [Time].[Year].&[1999], [Product Line].[All 
Product Line], [Customer].[Country].&[Canada].&[Cliffside] )