Direct DB Request and Integer Problem on Column Selected

Sometimes when you do a direct database Request especially from Oracle you have problems when a number to obiee is an integer

Do the below to resolve .. In your sql statement CAST(yourcolumn AS double precision)

To change integer into double precision ---

select CAST(yourcolumn AS double precision)
from Yourtable