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
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
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,
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
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..
looks like this same issue persists for 4.1 Sp5. pretty annoying that you can't do an OR operation.
Add a comment