Skip to Content

                                                                      IF..ELSE..THEN functions in BEX

  •     For suppose, the query has if, else and then functions

IF_Else_Image.PNG

Limitations:

  • There is no specific function for IF.
  • If we specify Condition like *0 + 1 then the condition will wont work.

Thanks & Regards

Trinadh Kumar Reddy B

Senior Software Engineer

iGATE GLOBAL SOLUTIONS

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Trinadh Reddy Badvel Post author

      Actually in our case we maintain intially then 0 else 1 but its not populating data in report output.

      When i changed to then 1 else 0…then the condition is woking…..I though that would be the BW Bex Limitation…I have developed like that 40 Queries….Same Output is reflecting…

      (0) 
  1. Benedict Venmani Felix

    For a document, you could have put some more effort in showing some result screens.

    Are you sure this would work. Because I think a BEx condition like thiss would return a value ‘1’ IF TRUE and would return ‘0’ IF FALSE.

    So as per your formula if GROSS < BASE the result would be ‘1’ (1*1+ 0 )

    (0) 
    1. Trinadh Reddy Badvel Post author

      Actually in our case we maintain intially then 0 else 1 but its not populating data in report output.

      When i changed to then 1 else 0…then the condition is woking…..I though that would be the BW Bex Limitation…I have developed like that 40 Queries….Same Output is reflecting…

      (0) 
  2. John K

    Hi Reddy,

    Whenever you post any document that should have the clear explanation and proper solution. I Think it’s your first post, don’t shame to post again try to keep the following tips for your upcoming post.

    The people will get know something form your post.

    Every post for fresher’s and unknown person’s not for known think this in you mind.

    Even you are posting basic try to explain with real time example.

    Regards,

    John.

    (0) 
    1. Trinadh Reddy Badvel Post author

      I have posted exact scene of the scenario….from next time onwards i will try to elabrate the Scanario and then i will post the document.

      Thanks for giving your valuble feedback.

      Regards

      Trinadh Reddy B.

      (0) 

Leave a Reply