COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: VizWiz on 24 Apr 2019 02:15:54 PM

Title: Yet Another Cognos Rounding Question
Post by: VizWiz on 24 Apr 2019 02:15:54 PM
Hi Everybody,

I've noticed that when upgrading a report package from CQM to DQM, the rounding actually changes for crosstabs and graphs (but not lists for some reason). I should also mention I'm using an Oracle database and, for the rounding, I'm using the function "round" (NOT "_round"). I thought this meant that it is using the Oracle function for rounding, not the built-in Cognos function. This makes things even more puzzling for me, because if Cognos is truly pushing the rounding off to the database, why on earth would switching from CQM to DQM change this behavior?

Anyone have any thoughts/comments/suggestions? I currently have a ticket open with IBM that they are taking their time to respond to.

Thanks!