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!

Help Required in CASE statement OBIEE

1056631Mar 4 2014 — edited Mar 4 2014

Hi All,

I need help on Case statment in OBIEE. I am using OBIEE 11g.

The requirement is like that I need to do the calculation in the column like below:

WHEN "TASK"."WBS Level" = '1' THEN "FACTS_EXPENDITURE"."Acct Burdened Cost CFY_CFM GT" ELSE "FACTS_EXPENDITURE"."Acct Burdened Cost CFY_CFM GT Task Detail"

When I use the CASE statement in Edit column dialogue box, I am getting error like "Invalid Alias Format : Table_name.Column_name required". I used the below statement:

CASE WHEN "TASK"."WBS Level" = '1' THEN "FACTS_EXPENDITURE"."Acct Burdened Cost CFY_CFM GT" ELSE "FACTS_EXPENDITURE"."Acct Burdened Cost CFY_CFM GT Task Detail" END

Please help.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2014
Added on Mar 4 2014
#11g, #answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #obiee11g, #oracle, #report
2 comments
678 views