Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Arithmetic overflow error converting expression to data type int

1037520Jan 10 2018 — edited Jan 10 2018

Hello,

I'm working obiee 12c with sqlserver datawarehouse. I get this error in a calculated column when i run the analysis.

[nQSError: 16001] ODBC error state: 22003 code: 8115 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int..

when i see the datatype for the calculated column at the business model, it shows DOUBLE. I can´t change it because obiee sets the datatype for the column.

Does some one know what can i do?

Thanks a lot.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2018

Added on Jan 10 2018

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

339 views