Arithmatic Overflow Exception in Charts

[jayatu]

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

[BigChris]

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.

[jayatu]

Hi BigChris,

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

Thanks,
Jayatu

[BigChris]

Bang goes that theory then...

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