Cognos Analytics

 View Only
Expand all | Collapse all

How to set Decimal Precision on Cognos Reports

  • 1.  How to set Decimal Precision on Cognos Reports

    Posted Mon November 04, 2024 10:44 PM

    Hi Everyone,

    We are getting "PDS-PPE-0104 A record was rejected. An arithmetic overflow occurred. -1,379,278,883 DMB-ECB-0070 PPDS Error." for one of our cognos report.

    We found that setting the decimal precision to a lower number might resolve this issue.

    Can anyone please let us know how to set this decimal precision to lower number. whether it can done on cognos report, package ?

    Thanks,
    Lokeswara



    ------------------------------
    Lokeswara Yerramreddy
    ------------------------------


  • 2.  RE: How to set Decimal Precision on Cognos Reports

    Posted Tue November 05, 2024 01:52 AM

    This is probably crosstab precision that you're after. This is a server side setting. I have put a link below for the IBM documentation. Or search the help for 'Reduce Decimal Precision'.

    Reduce Decimal Precision



    ------------------------------
    Marc Reed
    ------------------------------

    Original Message


  • 3.  RE: How to set Decimal Precision on Cognos Reports

    Posted Fri November 08, 2024 07:59 AM

    Thank you for your suggestion Marc

    Thanks,

    Lokeswara



    ------------------------------
    Lokeswara Yerramreddy
    ------------------------------

    Original Message