Summing inaccuracies

Last Post 01 Aug 2007 06:06 AM by foxjazz. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Rocky Raccoon
New Member
New Member

--
06 Jul 2007 07:11 PM
I have an AS 2005 cube with a measure based on a column defined as an integer. If I show the data by quarters I see: Q1 592574267, Q2 594649345, Q3 663084251 and Q4 751456630. If I display the entire year I see a negative number ( -1693202803). I suspected that the problem was that the sum of the 4 quarters exceeded the integer data type of the base column. However, after changing the base column to numeric (20,0) I still get the same bad data. Does anyone know how to fix this?
foxjazz
New Member
New Member

--
01 Aug 2007 06:06 AM
It seems to me your making way too much money for using sqlserver analysis server.
Maybe using base64 would be better, and possibly using 64bit sql where the integer is 64bit based.

We had the 16 bit integer, now the 32 bit in most cases but with sql 64 it's naturally 64bit integer.

Makes me wonder how they do math in Mexico or China.


Acceptable Use Policy
---