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 use CAST function in obiee 11g in rpd

867000Jan 3 2012 — edited Jan 3 2012

Hai,
I am trying to use the cast fucntion in rpd in bmm layer for a new logical column that I have created and is giving me error compile message.
Can any one please help me out or find out what is wrong in the function I am using.
The expression I am trying to use is
( CAST ( "Chase Card Acquisition"."Fact Deposit"."Base Earn" as decimal(18,0) ) + "Chase Card Acquisition"."Fact Deposit"."Tot Bonus Earn" )

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2012

Added on Jan 3 2012

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

4 comments

7,202 views