Question & Answer
Question
Previous to IBM Cognos Business Intelligence 10.2, the product used the round half to even rule when rounding numbers. The round half to even rule is widely used in bookkeeping. However, precision regulations in some regions require different rounding rules (for example, the round half up rule). With IBM Cognos Business Intelligence, you can now choose a rounding rule to comply with the precision regulations that apply to you.
Answer
There is an advanced setting that can now be set . "RSVP.RENDER.ROUNDING"
Here are the IBM Cognos BI rounding rules and descriptions
Rule | Description |
halfEven | Round to nearest neighbor, where an equidistant value is rounded to the nearest even neighbor. This is the default rule. |
halfDown | Round to nearest neighbor, where an equidistant value is rounded down. |
halfUp | Round to nearest neighbor, where an equidistant value is rounded up. |
ceiling | Round to a more positive number. |
floor | Round to a more negative number. |
down | Round towards zero. |
up | Round away from zero. |
Steps:
1. Launch IBM Cognos Administration.
2. On the Status tab, click System.
3. In the upper left corner of the Scorecard pane, click the arrow to view the Change view menu,
point to Services and then click Batch Report.
4. Click the arrow next BatchReportService, and then click Set properties.
5. Click the Settings tab.
6. Click Edit next to Advanced Settings.
7. Select Override the settings acquired from the parent entry.
8. In the Parameter column, type RSVP.RENDER.ROUNDING
9. In the Value column, type one of the values in the above table.
10. Click OK.
11. On the Set properties page, click OK.
12. Repeat the same steps for Report service
====================================================
Due to the following APAR one more step is required.
APAR PI27812: Round halfUp rule does not work as expected
Edit ~install directory~/webapps/p2pd/WEB-INF/services/cgsService.xml and add the following line.
<child-proc-cmd>RSVP.RENDER.ROUNDING=halfUp</child-proc-cmd>
Example:
<externalProcess>
<!-- JVM arguments -->
<child-proc-cmd>-option</child-proc-cmd>
<child-proc-cmd>COG_ROOT=</child-proc-cmd>
<child-proc-cmd>RSVP.RENDER.ROUNDING=halfUp</child-proc-cmd>
<child-proc-cmd>-vmargs</child-proc-cmd>
<child-proc-cmd>Xmx1g</child-proc-cmd>
<child-proc-cmd>DuseNonAsync</child-proc-cmd>
Related Information
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21643228