Hi All,
I have to apply cardinality condition filter in webi report.
As per the query filters are like these
(
Table2.Installation = 'France'
AND
Table1.Unit = 'France'
)
But I have to add condition on Table1.Unit.
Expected:
(
Table2.Installation = 'France'
AND
Table1.Unit (+) = 'France'
)
I tried to add this condition at oracle data source side and it is working but when i tried to do same in custom query, it is giving validation error.
Can somebody please help me with how this can be achieved?
Thanks in advance!