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
integer imported as double
we have fields in our oracle database identified as integer, but when they get imported into the physical layer they are changed to 'double'. Is there
a default setting in OBIEE that's doing this ?
Answers
-
Actually I don't think there is a setting managing that but it's also what I saw. It generally isn't a problem as integer can be a double (the opposite would be a real issue).
Does this change from integer to double give you problems somewhere?
0 -
Check this OBIEE - Integer Datatype [Gerardnico]
this explains why it does!
0 -
I hope you do know that an OBIEE integer is a 32bit SIGNED INTEGER!
So you might want to NOT use integer if you're storing anything above 2'147'483'647 (or below -2'147'483'647) or you'll get Youtube-like Gangan-Style-itis.
Basically you're hitting slide 5 of my worst practices: 50 shades of #Fail - Oracle BI worst practices in real life ;-)
0
