Table of Contents

OBIEE - Integer Datatype

About

In OBIEE, the integer datatype:

Oracle

To have an integer from the Oracle database, you must:

Division

When both operands are INTs, OBIEE perform an integer division.

An integer division give the integer quotient as: <math>26/10=2</math>

To perform floating point division, the datatype must be changed to a floating point type as for instance by using or use the CAST function.

Example:

CAST(ColumnA AS DOUBLE) 
CAST(ColumnA AS DOUBLE) / ColumnB)

Support

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.

Obiee Integer Format Wide Default

Documentation / Reference