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!

CASE Statement Edit Column Formula

978451Jan 15 2013 — edited Jan 15 2013

Hi,
I have the following CASE statement in the Edit Column Formula. It keeps giving me an error of "Invalid Alias Format: Table_name.Column_name required"

CASE
WHEN "CMO/ARM"."SP Rating"='AAA' THEN 1 ELSE
WHEN "CMO/ARM"."SP Rating"='AA' THEN ' ELSE
WHEN "CMO/ARM"."SP Rating"='A' THEN 3 ELSE
WHEN "CMO/ARM"."SP Rating"='BBB' THEN 4 ELSE
WHEN "CMO/ARM"."SP Rating"='BB' THEN 5 ELSE
WHEN "CMO/ARM"."SP Rating"='B' THEN 6 ELSE
"CMO/ARM"."SP Rating"=100
END

Any tips anyone? What am I doing wrong here? CMP/ARM is a table in the presentation layer. The column is actually mapped to a different VIEW underneath.
Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2013

Added on Jan 15 2013

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

4 comments

501 views