Maybe this additional information can help you recommend a solution to my problem (quoted below):
The datatype for the field/column under question in my datamart is float (which is giving me the correct results). What should I change the Data Type of my measure in the Cube Editor to ??? to get the same results?
When I check the totals for various dimensions in the database which is used for my cube, I get the correct results (I have tallied them with the results from my OLTP)...
But when I browse my cube (using the same parameters, or should i say dimension combination) i get different results as compared to what I mentioned earlier