Numeric Overflow Error When Loading Large Numbers into CRM Analytics via Data Connection

As part of the value conversion, it converts the whole number to an integer; depending on the scale this can exceed the overall number size beyond the supported length. The value supports upto 17 decimals (17 length) for the integer inserted and the scale determines the multiply by x to get the number.

For example,

4077232274536.00 > first adding the extra decimal places for the scale of 4 > 4077232274536.0000. Then converting to the full value (since Scale is 4, it multiplies by 10,000) > 40772322745360000 this brings it to 17 decimals.

The value is stored as above and as soon as it exceeds 16 in length; in an org without null measure handling enabled, it will fail with numeric overflow. With null measure handling enabled, it supports 17 decimal places at maximum. 

NOTE :

• Precision :  The maximum number of digits in a numeric value, includes all numbers to the left and to the right of the decimal point (but excludes the decimal point character).
• Scale : The number of digits to the right of the decimal point in a numeric value, must be less than the precision value.