Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Decimal value issue while displaying in Prompt

Rajagopal R-OracleJul 5 2017 — edited Jul 6 2017

Hi.,

We have number(20) column in Database , when we import that in RPD that is converted as Double.

When we use that column in Reports we are able to remove the decimal places and able to display the value in integer format., but when we use the value in dashboard prompt it's showing the values in decimal places , when we do (Cast as int) getting "Numeric Overflow Occured" error,

Ex: if the value in database '140023000000000'

prompt - 140023000000000.0000

I wanted to display the value '140023000000000' in dashboard prompt.

any inputs?

thanks

Raja
This post has been answered by Gianni Ceresa on Jul 5 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2017
Added on Jul 5 2017
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
5 comments
1,545 views