Error processing cubes

  • I've found 4 fields which cause the Conversion overflow.

    1 example: "TotalRevenueLCY".

    The total sum value in SQL: 858376803445.19000000000000000000

    Min value: -2243974.89000000000000000000

    Max value: 429080429080.00000000000000000000

    When I put this field as only measure in the measuregroup, I get the overflow conversion.

  • rc 77550 (9/11/2015)


    I've found 4 fields which cause the Conversion overflow.

    1 example: "TotalRevenueLCY".

    The total sum value in SQL: 858376803445.19000000000000000000

    Min value: -2243974.89000000000000000000

    Max value: 429080429080.00000000000000000000

    When I put this field as only measure in the measuregroup, I get the overflow conversion.

    Those are big numbers, but shouldn't a double be able to handle those?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply