OBIEE - Integer Datatype

Obi Edition


In OBIEE, the integer datatype:

  • follows the rule of an integer division (without the decimal part)
  • is mandatory for some OBIEE intern use such as the LOGLEVEL variable or the indexcol function


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

  • of create a number(1)
  • of perform a cast as number(1) in your SQL statement


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.


  • 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.

Obiee Integer Format Wide Default

Documentation / Reference

Discover More
Obiee Security User Indexcol
OBIEE - IndexCol Function - Handle hierarchy Level security

The INDEXCOL function helps to select the appropriate column and behave as the IF THEN structure. It can then use external information to return the appropriate column for the logged-in user to see. ...
Obiee Direct Db Number Piplined
OBIEE - Table Function/Stored Procedure in Direct Database Request

How to use a table function with the direct database request Then in the direct database request add this statement When you use a table function, you may have the surprise to see that BI...
Obiee Setting Admnistration
OBIEE 10G/11G - How to see the Physical SQL generated by a request in Presentation Service ?

A quickway to see the content of the Nqquery.log to grab the SQL information is to follow this quick instructions. Click Settings > Administration > Manage Sessions > View Log to view the query log and...
Obiee11g Default Logging Level
OBIEE 10G/11G - Setting a Query Logging Level

The login level is a parameter which control the number of information that you will retrieve in the log file from nothing (level 0 - no_log_found) to a lot of information (level 5). You can enable logging...

Share this page:
Follow us:
Task Runner