Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details