Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Obiee 12c decimal problem
3416339
Rank 1 - Community Starter
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.
0
Answers
-
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.
0