BI Publisher (MOSC)

MOSC Banner

NUMBER(15) DB columns limits pivot table values to 2 147 483 647, wrongly displaying higher values

edited Feb 25, 2019 8:28AM in BI Publisher (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center