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?

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

783 views