Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Obiee 12c decimal problem

Received Response
13
Views
1
Comments
3416339
3416339 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.