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!

"Unresolved identifier" when using WHEN CASE function

2973433Jul 27 2015 — edited Jul 27 2015

Hi,

I want to create following measure:

CASE WHEN "MODEL"."Customer"."name"=Mark THEN 1 ELSE 0 END

but I get error:

Unable to create Expression

CASE WHEN "MODEL"."Customer"."name"=Mark THEN 1 ELSE 0 END

due to following error(s):

[nQSError: 27009] Unresolved identifier: "Mark".

It seems like I can only put numbers as value (ie "1" instead of "Mark") and then it works. Why cant I put any text values?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2015

Added on Jul 27 2015

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

3 comments

786 views