Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jayatu on 27 Nov 2014 07:17:15 AM

Title: Arithmatic Overflow Exception in Charts
Post by: jayatu on 27 Nov 2014 07:17:15 AM
Hi,

I have a query that returns two matrices, that have large values.

Date                  Metric1                            Metric2
Nov 2, 2014    12,976,974.9647274   62,514.50251351
Nov 3, 2014    12,966,853.8528871   62,514.47391957
Nov 4, 2014    12,983,137.8364711   62,492.63182023

If I am displaying this as a list in the reoport there are no issues the report runs fine.

But if I display the same info in a chart (a Bar chart) I get the following error
A record was rejected. An arithmetic overflow occurred. PDS-PPE-0104 A record was rejected. An arithmetic overflow occurred. (Data)

Why is cognos behaving differently for the same query?

Thanks,
Jayatu
Title: Re: Arithmatic Overflow Exception in Charts
Post by: BigChris on 27 Nov 2014 07:51:43 AM
Have you tried exporting your list to excel (for example)? I'm guessing that you're only seeing part of the recordset in your listing.
Title: Re: Arithmatic Overflow Exception in Charts
Post by: jayatu on 27 Nov 2014 08:08:52 AM
Hi BigChris,

Yes I can export the list to excel. I have checked, entire data is displayed in the listing.

Thanks,
Jayatu
Title: Re: Arithmatic Overflow Exception in Charts
Post by: BigChris on 27 Nov 2014 08:44:40 AM
Bang goes that theory then...

A quick google search on the error code suggests that you're using a cube, is that right?
Text only | Text with Images