cancel
Showing results for 
Search instead for 
Did you mean: 

Difference between Union and OR in Webi Combined queries

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

amitrathi239
Active Contributor

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.

amitrathi239
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thanks Amit

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

When to use what?