Page 1 of 1

Cognos Data Size vs. Vertica Table Column Data Type Size

Posted: Fri Jan 27, 2012 9:45 pm
by JimKnicely
Hi,

We have a column defined in a Vertica table as numeric(12, 5). In this column we can store numbers as large as 9999999.99999. When we query the column in Cognos using the "auto sum" feature we get an error (see attachment). Cognos is apparently sizing the field to display the sum based the table's data type's precision and scale which is too small to hold the sum's larger size. Our solution was to re-size the column making it bigger (i.e. numeric(25, 5)). It worked, but oddly, we do not have the same issue when querying a MySQL database column defined as decimal(12, 5). Is MySQL better? Ha hah, just kidding.

Does any one know of a better solution? Perhaps a Cognos setting? Otherwise, I have to re-size a lot of numeric columns in our Vertica database!

Thanks

Re: Cognos Data Size vs. Vertica Table Column Data Type Size

Posted: Thu May 24, 2012 1:16 am
by the6campbells
Given the absence of any exception message from the Vertica ODBC driver in the exception you show, it suggests the expression error is local to query engine in the Report server running your scenario. You could attempt to review the Vertica ODBC API trace to confirm how it described the columns in the projection of the query in terms of type, precision and scale to confirm that was done correctly by the ODBC driver itself.