Webi Query Filter - Object from this Query is disabled
I am using BO 3.1 & when I am trying to filter a object in webi I am unable to select Object from this Query option. How do i enable this option?
I think i need to ask my Admin, What do you suggest?
HARDIK NIMBARK replied
Sorry for overlooking detail. As suggested by Mark, "Object from this query" only available when you use Single value operands like Equal to, Not Equal to, Less than, Greater than.
Lets say you use above option to form a condition like object 1 Not Equal to Object 2
From database point of view, above condition in SQL will be applied at the end. Once database prepares the result set to be returned, records in result set will checks Object1 and Object 2 values. Result set will return records where Object 1 and Object 2 values are different.
I hope above clarifies.