Problems with number types - MySQL

[tupina]

Hello,
My fact table has two Measures, aggregates by sum. The first, recovers data from a float camp and the second from an integer camp.
I'm utilizes MySql as DataBank.
My first problem is: Where datas comes from a float camp, the aggregation works. But, where datas comes from integer, the aggregation doesn't works, return blank values.
The second problem is: When I need give a drill-down in a float camp, where the float camp has decimal values, the drill-down doesn't works too.
Follow my fact-schema declaration:
----------------------------
<Measure name="Valor Total" column="valorTotal" type="Numeric" aggregator="sum" formatString="$#,##0.00"/>
<Measure name="Quantidade Total" column="quantidadeTotal" type="Numeric" aggregator="sum" formatString="#,###"/>
----------------------------
Are there anyone type to number type?
Tank's,
Rafael

[sgwood]

It looks like you have some problems with your underlying database. Are all the rows in the fact table filled in with the valorTotal and quantidadeTotal, and all foreign keys to the dimensions correct?
Can you show the MDX you are using that has the problems?
Sherman