- follows the rule of an integer division (without the decimal part)
When both operands are INTs, OBIEE perform an integer division.
An integer division give the integer quotient as: <math>26/10=2</math>
- In the repository, in a physical measure
CAST(ColumnA AS DOUBLE)
- In Answers, cast one of the operands is enough.
CAST(ColumnA AS DOUBLE) / ColumnB)
After import, I get a double with then a double zero as decimal
OBIEE perform an Integer Division as you can see in the paragraph above (I suppose that the program is then written in C). In short, when you have two integers in your division, the result will lost the decimal part. It's why when you import from Oracle for instance a NUMBER(10), it will set it as a DOUBLE.
To suppress the two zero decimal after the comma, one solution is to set for the column a system- wide default format with a decimal place to zero as below.