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!

How to convert a varchar to integer datatype in obiee Answers?

Ashish GuptaJul 4 2011 — edited Sep 27 2013

Hi Gurus,

I tried using cast to convert a varchar to integer type eg.

cast (column as integer) in fx in answers but its not working.

Can we use to_number function in answers?

Also do we have any other way of changing the datatype of a column rather than changing it in
Physical layer of the rpd.

Thanks
Ashish Gupta

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2013

Added on Jul 4 2011

#answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee

4 comments

12,108 views