Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Arithmetic overflow error converting expression to data type int
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.
Answers
-
Hi,
in the physical model of the rpd you can change the datatypes of columns.
Simples!
0 -
Tnks Robert, I did it... but the calculated column data type does not change at the business model.
Obiee always set double.... and double is not data type for sql server.
I don't understand the error.
0 -
Use the query tool within the rpd to query the column across to the alias (if there is one) to the logical table and make sure the data type change that you have made is consistent across all.
0 -
Sorry, just seen "in a calculated column" - if you do (for example) x / y or similar then the result may not be an int, I would suggest that you need to cast your int to a numeric type that can handle it in the analysis formula if you are doing anything that could result in decimal places.
0