on 10-18-2016 8:22 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Amit
I am just talking about the OR condition v/s Union combined query...
When to use what?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.