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!

"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