Controlling the Allocation Rounding Precision for Management Ledger Calculations

There is a hidden installation preference you can insert in the database to change the number of decimal places that allocation results are rounded to during Management Ledger calculation (the current default is 7 decimal places).

In the following SQL statements, replace <value> with an integer from -6 to 7 (keep the single quotes).

A value of -6 rounds to the nearest million; a value of 0 rounds to the nearest whole number; a value of 7 rounds to 7 decimal places.

During the allocation, the remainders from the rounding operations are added to the destination intersection with the largest allocated value.

For Oracle databases, execute this SQL statement in SQL Developer while connected as the Profitability product schema owner and then commit the change

INSERT INTO HPM_INSTALLATION_PREFERENCE

(ID,NAME,VALUE,HPM_INSTALLATION_ID,CREATED_TIMESTAMP,CREATED_USERID,MODIFIED_TIMESTAMP,MODIFIED_USERID,DISPLAY_ORDER)
VALUES (40,&apos;MLCalculationPrecision&apos;,&apos;<b>&lt;value&gt;</b>&apos;,1,SYSDATE,&apos;INIT&apos;,SYSDATE,&apos;INIT&apos;,40);

For Microsoft SQL Server databases, execute this SQL block in SQL Server Management Studio while connected to the Profitability product database:

BEGIN
     SET IDENTITY_INSERT HPM_INSTALLATION_PREFERENCE ON 
     INSERT INTO HPM_INSTALLATION_PREFERENCE 
     (ID,NAME,VALUE,HPM_INSTALLATION_ID,CREATED_TIMESTAMP,
     CREATED_USERID,MODIFIED_TIMESTAMP,MODIFIED_USERID,DISPLAY_ORDER)VALUES
     (40,'MLCalculationPrecision','<value>',1,getDate(),'INIT',getDate(),'INIT';,40)
     SET IDENTITY_INSERT HPM_INSTALLATION_PREFERENCE OFF
END
go