Hi. Folks at
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4dad8e33-315e-4d36-a781-94448ce7e7ad seemed anxious to mark my finding "answered" so I'm posting here for an explanation of what seems to be a bug in ssas.
I am getting different totals in one measure group depending on whether the ssas db is first deleted before processing. The total is incorrect if the db isnt first deleted prior to a "process full" on this measure group. The measure involved
is sourced from a money column that uses (all) 4 decimal places not just 2. For over 300 million facts, I havent seen the error amount to more than $1.15. But that is unacceptable in this app.
To some extent we've exhausted the money vs currency display argument. This doesnt seem to matter if we do a full deployment after the ssas db is deleted.
Is this a bug? Does it only affect measures sourced by money columns? Only if they go past 2 decimal places? Only after a large number of deletions and a few inserts in the source star table?
Normally, this measure group processes Add. Will I find that isnt working either? The star source row deletio
View Complete Post