COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: kenrisen on 22 Apr 2010 10:44:24 AM

Title: Error Aritmathic Overflow
Post by: kenrisen on 22 Apr 2010 10:44:24 AM
dear all..

i want share a little knowledge...
if someone got an Arithmathic Overflow error and didn't know how to solve that problem..

pls try :

1. change the measure that have a lot of digit with query calculation
2. in query calculation put the measure that you want to view but don't forget to use cast. Please cast the measure to decimal (16,2)
3. change the aggregate measure in query calculation properties become Total (don't use Automatic)

..hope can help..

correct me if i'm wrong..:)
Title: Re: Error Aritmathic Overflow
Post by: MFGF on 22 Apr 2010 12:05:50 PM
Hi,

Thanks for sharing - much appreciated!  :)

MF.
Title: Re: Error Aritmathic Overflow
Post by: kenrisen on 22 Apr 2010 10:05:42 PM
hi MF...:)