Obiee 12c decimal problem

3416339

Hi,

We can use obiee 12.2.1.2.0. We have a problem about number decimal.

We saw number on database different on report after the comma,

In database 162849202712378,54 , the visible field appears as report 162849202712378,00.

Even though I change the type of the field, the result is still the same.(CAST("FACT PRODUCT"."TOTAL" AS DOUBLE))

Also type of field is the same with admin tool and database. Both of them is double.

[Deleted User]

a) What's the source database?

b) Are you certain that the data type in the BMM layer and physical layer it is DOUBLE?

c) CASTing it to a DOUBLE in Answers if it's an INT or something like that at some other point is absolutely pointless because by then the decimal places have already been dropped.