Skip to Content
author's profile photo Former Member
0
Former Member

No "OR " Function for WEBI using BEX (BO 4.0 )

Posted on Nov 27, 2011 at 04:52 PM 1.3k Views

Hello Experts,

I am using Business Objects 4.0 SP2 with SAP BEX.

I am using WebI and from WebI I direcltly connect to BEX connection and pull the report.

In the query pannel when i use the filter with AND operator it works fine but if I need to give an OR condition then

I am not able to as it seems that BEX do not have OR condition.

Then I tried to use report filter with AND/OR operator inside the report then for all the measures are giving me an error

  1. Unavilable.

Now then I thought to use UNION and this is disbaled for me.Please let me know how can i achive this

A OR B using AND is this possible?

Regards

Lekshmy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Nawale EL MAAZI
    Nawale EL MAAZI
    Posted on Feb 17, 2012 at 11:06 AM
    2

    Hi everyone !

    I'm using BI 4.0 SP02 Patch 9 and the problem with "OR" Operator is still there when you use a query BEX.

    Can somebody tell me if this point will be fixed by SAP with the next patch (10, 11, 12) ?

    Thank you for your help. I really need this operator for my reports.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo ravi rawat
    ravi rawat
    Posted on Nov 28, 2011 at 01:33 PM
    0

    Hi ,

    You can create a variable and use inlist in filters.

    For example: if you want filter on A or B.

    create variable v_ab= if(dim1=A;1;if(dim2=B;2;3))

    Drag in report filter and in inlist select 1,2. In this way u can use OR if it is not working.

    Hope this is your requirement.

    regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Henry Banks
    Henry Banks
    Posted on Nov 29, 2011 at 11:36 AM
    0

    Hi

    UNIONS are definitely out for OLAP queries.

    With regards to the WebI query filters - I have never tried an "OR" operator on a BICS/ BEx query.

    However, webi prompts using Boolean OR operator were definitely possible in XI3.1 with SAP integration Kit, via the MDX BAPI.

    If i were you I would contact Support to get an official answer.

    Regards,

    H

    p.s. I found that you cannot filter on a measure via BICS, and also bex conditions aren't supported either - so there's no way of doing a dynamic "greater than xx" on a key figure at runtime..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 03, 2011 at 03:34 AM

      Hello Experts ,

      Request your help as this is urgent .

      A =("YY","XX") OR ( (B="LL","KK") AND (C="KK","MM") )

      This is what I need to achive ...Please help me as using BEX I am not able to achive OR in BO or BEX.

      Regards

      Lekshmy

  • author's profile photo gary martins
    gary martins
    Posted on Nov 12, 2015 at 01:58 PM
    0

    looks like this same issue persists for 4.1 Sp5. pretty annoying that you can't do an OR operation.

    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.