SSAS 2008 R2. I have a fact table with a field "Debit" of type numeric (10,2). My named query in the DSV (Data Source View) casts the field as money , cast(debit as money) as "Debit". When I browse the cube in BIDS I see the sum of Debit for the fiscal year (dimension) with more than two decimal positions (it actually has 6 decimal positions). How can I force it to be only two?