Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
12c Precision Problem
Hi,
I created a "tablecar" and one columns as "Price NUMBER(25,2)" , car_name varchar2(3 byte).
In Toad;
select * from tablecar;
| Price | Car_Name |
|---|---|
| 1341,15 | abc |
| 1402,84 | def |
In 11g shown as;
| Price | Car_Name |
|---|---|
| 1341,15 | abc |
| 1402,84 | def |
In 12c shown as;
| Price | Car_Name |
|---|---|
| 1341 | abc |
| 1403 | def |
In rpd, typed as double in same system. I do not want to need to change as column properties-> Data Format-> Decimal Places->2 .
If the column build as number(x,2) , report must show what accuately this column created as dataase.
Is there any special settings for this?
Version : Oracle Business Intelligence 12.2.1.2.0
Thank you,
Evren
Answers
-
The number formats in OBIEE are set in the properties for the column in answers, and yes, it can support 2 d.p.
0 -
In 11g it is not necessary to set this settings.
In 12c, Report not show what column is created as database. There should be general setting for this.
0 -
You will have to apply a format, Like Robert already said, this can be done in answers:
0 -
3506585 wrote:In 11g it is not necessary to set this settings.
Are you really sure?
Didn't you just set a system-wide default for that data type in your 11g?
Because out of the box I'm kind of sure 11g always display numbers without any decimal ...
0 -
Hi Gianni, You are right. Thank you
0
