Hi,
I am trying to solve a numeric overflow issue on the Cognos Dashboard.
On the Cognos Report authoring we have options to update the query items to have type casting before the Aggregation applied..
Example - FIELD1 changed to "CAST(FIELD1 as DECIMAL (15,3))". And then these type cast applied before the field aggregation/Sum done.
SELECT FIELD0,
SUM(CAST(FIELD1 AS DECIMAL(15, 3)))
FROM TABLE1
GROUP BY FIELD0
Cognos Dashbaord I have created a calculation for FIELD1_CALC as "CAST(FIELD1 as DECIMAL (15,3))". The SQL generated for the Dashboard chart as below.
SELECT FIELD0,
CAST (
SUM(FIELD1) AS DECIMAL (15,3))
FROM TABLE1
GROUP BY FIELD0.
This causing the numeric overflow on SQL execution and query getting failed.
Can you please let us know if there are any way we can have the CAST done before the SUM?
------------------------------
Chandrashekhara Kundadka
------------------------------
#CognosAnalyticswithWatson