NUMBER(15) DB columns limits pivot table values to 2 147 483 647, wrongly displaying higher values
Problem description:
====
DB column of data type NUMBER(15) translates to Long in data model and pivot table values become limited to 2 147 483 647.
BIP 12.2 Standalone is used. OS is RHEL 6.
Problem can be reproduced as follows.
New table OE.EMP2 created (by copy of employees table) and new column ANNUAL_SAL NUMBER(15) added to it. ANNUAL_SAL = SALARY*12*10000. This was needed to ensure the sum of ANNUAL_SAL values clearly surpasses 2 147 483 647, the maximum number that can be represented by a signed 32 bits integer. As can be seen in the attached report only the pivot table's sums by department and its grand-total are affected. Showing the max value it can represent, instead of the real value, much higher.