Skip to Content
0

Difference between Union and OR in Webi Combined queries

Oct 18, 2016 at 07:22 PM

178

avatar image

Hi guys

Could you guys explain in what scenarios do I need to use Union and where to use OR?

It sometimes gets a bit confusing

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Oct 18, 2016 at 07:43 PM
1

Sub queries are helpful when you need data based on multiple filter conditions but number of objects with same datatype in webi select part are same.

Like you need some data where year equal to 2006 and some data where year is different with some other conditions.in that case one option is use two queries and use merged dimension at webi level. or combined queries where you can use UNION,INTERSECTION or MINUS operator to get the result with single webi query.

There is no OR operator in combine query.

Share
10 |10000 characters needed characters left characters exceeded
nutty buddy Oct 19, 2016 at 05:19 PM
0

Thanks Amit

I am just talking about the OR condition v/s Union combined query...

When to use what?

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Oct 19, 2016 at 07:10 PM
0

OR condition you can use in the webi query filters block.

OR conditions are useful when users wants to see the data either of one condition. In this case you can make both conditions as optional.User will enter values in one to get the data.

e.g two conditions like on country or Year both options..users can see the data either by entering country or year.

in individual combined queries you can create OR conditions.

Share
10 |10000 characters needed characters left characters exceeded