Skip to Content

Case statement in filter condition not working IDT SAP 4.1 sp3

Hi guys

I need to have a case statement for a new filter I need to have in blx as below:

case when (fact_table.event_key in (4,5)) then 'Current' else 'old'

I get an error message saying 'the where clause result type is not boolean'

any idea why?

cheers

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2016 at 03:38 AM

    Hi,

    You missed the End Key word at the end of script please use below..

    case when (fact_table.event_key in (4,5)) then 'Current' else 'old' end


    Like e.g. CASE WHEN "EMPLOYEE"."SAL" IN(100,200) Then 500 ELSE 200 END

    Regards

    Niraj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.